Obtaining an OLE DB provider for your database

Obtaining an OLE DB provider for your database

An ASP.NET application must connect to a database through an OLE DB provider. The provider acts as an interpreter that lets an ASP.NET application communicate with a database. For more information on OLE DB and the role of database providers, see Communicating with the database.

If you want to connect to a Microsoft SQL Server database, you can use the Managed Data Provider for SQL Server that comes with the .NET Framework 1.1 SDK. This provider, which is optimized for SQL Server and is very fast, is installed when you install the SDK.

If you want to connect to a database other than SQL Server, make sure an OLE DB provider for your database is installed on the computer running the .NET Framework. You can obtain an OLE DB provider for Microsoft Access by downloading and installing the Microsoft Data Access Components (MDAC) 2.7 package from the Microsoft website at http://msdn.microsoft.com/data/mdac/downloads/.

You can download OLE DB providers for Oracle databases from the Oracle website at www.oracle.com/technology/software/tech/windows/ole_db/index.html. You can also purchase OLE DB providers from third-party vendors.

Once you have a provider for your database, you can use it to create database connections in Dreamweaver. See Creating an ASP.NET database connection in Dreamweaver.

Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly