OLE DB providers

An OLE DB provider is required for each type of data source you want to access. Each OLE DB provider is a dynamic-link library. To access SQL Anywhere, choose one of the following OLE DB providers:

  • Sybase SQL Anywhere OLE DB provider   The SQL Anywhere OLE DB provider provides access to SQL Anywhere as an OLE DB data source without the need for ODBC components. The short name for this provider is SAOLEDB.

    The SAOLEDB provider is self registering. This registration process includes making registry entries in the COM section of the registry so that ADO can locate the DLL when the SAOLEDB provider is called. If you change the location of your DLL, you must re-register it.

  • Microsoft OLE DB provider for ODBC   Microsoft provides an OLE DB provider with a short name of MSDASQL.

    The MSDASQL provider makes ODBC data sources appear as OLE DB data sources. It requires the SQL Anywhere ODBC driver.

See also