OLE DB providers are the OLE DB components used to access a source of data. The Microsoft OLE DB Provider for ODBC allows ODBC data sources to be used as sources of OLE DB data. The OLE DB Provider for ODBC can be used with the Microsoft® SQL Server™ ODBC driver to access SQL Server databases. Alternatively, the Microsoft OLE DB Provider for SQL Server offers optimized access to SQL Server databases. You can use this provider with SQL Server version 6.5 after you run the SQL Server 7.0 Instcat.sql at the computer running the earlier version.
Because each OLE DB provider has properties specific to the provider, your database may require that additional properties be set to connect to it. These properties can be set using the Advanced tab when you specify a data source or a data destination using the DTS Import and DTS Export wizards. For more information about the OLE DB provider advanced properties, see your OLE DB provider documentation.
Note The primary source of information regarding the use of OLE DB is the OLE DB Programmer’s Reference Version 2.0 available with the OLE DB Software Development Kit (SDK).
Programming OLE DB SQL Server Applications | Initialization and Authorization Properties |