OLEDB PROVIDERS

WHAT ARE THE NAMES OF THE VARIOUS OLEDB PROVIDERS?
PROVIDER NAME: PROVIDER FOR:

MSDASQL ODBC*
SQLOLEDB SQL Server
Microsoft.Jet.OLEDB.3.51 Jet 3.51**
Microsoft.Jet.OLEDB.4.0 Jet 4.0***
MSDAORA Oracle
ADSDSOOBJECT Active Directory Service
MSIDXS Microsoft Index Server

* Others (i.e. Sybase, etc.) may be summed up in the OLEDB Provider for ODBC.
There is no OLEDB Provider for FoxPro - You MUST use the OLEDB Provider for ODBC.
** Microsoft.Jet.OLEDB.3.51 does NOT ship with Versions 2.1 and greater of the MDAC Components.
*** Microsoft.Jet.OLEDB.4.0 ships with Version 2.1 of the MDAC Components as well as SQL Server 7.0

Additionally, to see which are available on your machine:
Right Click on your Desktop and choose New, then choose Microsoft Data Link. An Icon will be placed on your Desktop. Double Click on the Icon and take a look at the Provider Tab.

RETURN TO HOME PAGE