ASA Database Administration Guide
Connecting to a Database
Connecting to a database using OLE DB
You need an OLE DB provider for each type of data source you wish to access. Each OLE DB provider is a dynamic-link library. There are two OLE DB providers you can use to access Adaptive Server Anywhere:
Sybase ASA OLE DB provider The Adaptive Server Anywhere OLE DB provider provides access to Adaptive Server Anywhere as an OLE DB data source without the need for ODBC components. The short name for this provider is ASAProv.
When the ASAProv provider is installed, it registers itself. This registration process includes making registry entries in the COM section of the registry so that ADO can locate the DLL when the ASAProv provider is called. If you change the location of your DLL, you must reregister it.
For more information about OLE DB providers, see Introduction to OLE DB.
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 Adaptive Server Anywhere ODBC driver.