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.