Make your own free website on Tripod.com

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