Home | News | Tutorials | Visual Basic | HTML | About Us | Contact Us | Links
In this lession we'll cover how to set up a Data Environment in VB.
Start your compiler and open a project. Go to the Project option of the menu bar and select components. Inside the components windows click the designers tab and check Data Environment. Close the window by pressing ok. From the Project menu again, Look for Add Data Environment (it might be located under the More ActiveX Designers option). A data link window will come up asking you to set some properties. On the Provider tab pick the data provider you wish to connect to. For SQL Servers use OLE DB for SQL Server, and for Access 2000 use MS Jet 4.0 (Access 97 uses Jet 3.51). Click the next button or the connection tab. Type in a valid server name to connect to. If your Database uses the same login as windows NT select the Use Windows NT Integrated Security box. Now enter the database on the server you wish to access. Push the Test Connection Button.