Using OLE DB Providers with ADO

See Also   

Much of the power and flexibility of ADO is due to the fact that it can connect to any of several different data providers and still expose the same programming model, regardless of the specific features of any given provider.

However, because each provider is unique, how your application interacts with ADO will vary slightly between different providers. The differences you need to be aware of usually fall into one of three categories:

Provider-specific details in each of these three areas are listed for each of the providers currently available from Microsoft, listed as follows.

Area Topic
ODBC databases Microsoft OLE DB Provider for ODBC
Microsoft® Index Server Microsoft OLE DB Provider for Microsoft Index Server
Microsoft® Active Directory Service Microsoft OLE DB Provider for Microsoft Active Directory Service
Microsoft® Jet databases OLE DB Provider for Microsoft Jet
Microsoft® SQL Server Microsoft SQL Server OLE DB Provider
Oracle databases Microsoft OLE DB Provider for Oracle

Provider-Specific Dynamic Properties

The Properties collections of the Connection, Command, and Recordset objects include dynamic properties specific to the provider. These properties provide information about functionality specific to the provider beyond the built-in properties ADO supports.

After establishing the connection and creating these objects, use the Refresh method on the object's Properties collection to obtain the provider-specific properties. Refer to the provider documentation and the OLE DB Programmer's Reference for detailed information about these dynamic properties.

See Also   For more information about OLE DB providers, see the documentation for Microsoft® OLE DB in the Data Access SDK or visit the Microsoft Data Access Web page at http://www.microsoft.com/data.