- #Microsoft ado data control 6.0 oledb download how to
- #Microsoft ado data control 6.0 oledb download driver
- #Microsoft ado data control 6.0 oledb download code
Visual InterDev also adds code to the project's Global.asa to define the connection properties, which Listing 1 shows. When you insert the data connection into an application, Visual InterDev creates a Data Environment folder in Project Explorer and puts the data connection into this folder. OLE DB is making progress toward the goal of providing a universal data layer to the many different types of data that businesses need today. For example, by installing Visual InterDev 6.0 and SQL Server 7.0 on my system, I can access all the providers listed in Screen 3. OLE DB providers let you use many different types of data. This setting will result in improved performance. After you make this change and click OK, the connection will use SQLOLEDB. To use the OLE DB provider instead, select Microsoft OLE DB Provider for SQL Server. This option was the standard for ADO before native OLE DB providers became available. Select the Use Connection String option, and click Build to display the Data Link Properties dialog box, which Screen 3 shows.īy default, a new connection will use the Microsoft OLE DB Provider for ODBC drivers. Right-click the data connection name, and select Properties to display the Connection Properties dialog box. (For an explanation of data sources, see "Sorting Data Sources," page 42.)Īfter you add a data connection to your project, you can inspect the connection's properties. If you click this button, Visual InterDev will test the data source for you. (In my test data source, I chose the Northwind sample database by selecting the Change default database option and selecting the Northwind database from the drop-down list.) The data source setup is complete when you see a prompt showing Test Data Source. Answer the prompts on each successive page until you complete the data source definition. Then, select SQL Server from the list of drivers. To create a new data source, click New on either the File Data Source tab or the Machine Data Source tab. The Select Data Source dialog box will appear, as Screen 2, page 38, shows. For this example, accept the default settings for the remaining steps.Īfter you've created a new project, you can add a data connection to it by right-clicking Global.asa in Project Explorer (Visual InterDev's project interface) and selecting Add Data Connection. Next, enter the name of the server to host the new Web application, and click Next. Assign a name to the project in the Name text box, and click Open to start the New Web Project Wizard. Start Visual InterDev by clicking the New Web Project icon in the New Project dialog box, which Screen 1, page 38, shows. The Data Environment is simply an ADO wrapper that lets you develop faster and cleaner applications than if you developed them directly in ADO.įirst, let's create a new Web application to test the data connection: In the Start Menu, click Programs, Visual Studio.
#Microsoft ado data control 6.0 oledb download how to
To demonstrate how to use the SQLOLEDB provider with Visual InterDev 6.0, let's create a new Web site and add a data connection with Visual InterDev's new Data Environment. However, SQL Server 7.0 includes the native Microsoft OLE DB Provider for SQL Server, the SQLOLEDB driver, for use with ADO. SQL Server originally didn't have a native OLE DB provider you could use with ADO.
#Microsoft ado data control 6.0 oledb download driver
In SQL Server 6.x, the primary provider for connecting Visual InterDev and most other applications to databases was the MSDASQL driver or Microsoft OLE DB Provider for ODBC.
To create a new data connection for an application, you must first decide which OLE DB provider to use with the connection. In this article, I focus on how to use development tools with SQL Server to create Web applications. SQL Server 7.0's power and scalability combined with many new Internet and intranet features make it a great candidate for use in Web applications. Microsoft designed SQL Server 7.0 to scale up well in high-volume database applications. How to use Visual InterDev's new features to create a Web application