ASA Programming Guide
The OLE DB and ADO Programming Interfaces
OLE DB is a data access model from Microsoft. It uses the Component Object Model (COM) interfaces and, unlike ODBC, OLE DB does not assume that the data source uses a SQL query processor.
Adaptive Server Anywhere includes an OLE DB provider named ASAProv. This provider is available for current Windows and Windows CE platforms.
You can also access Adaptive Server Anywhere using the Microsoft OLE DB Provider for ODBC (MSDASQL), together with the Adaptive Server Anywhere ODBC driver.
Using the Adaptive Server Anywhere OLE DB provider brings several benefits:
Some features, such as updating through a cursor, are not available using the OLE DB/ODBC bridge.
If you use the Adaptive Server Anywhere OLE DB provider, ODBC is not required in your deployment.
MSDASQL allows OLE DB clients to work with any ODBC driver but does not guarantee that you can use the full range of functionality of each ODBC driver. Using the Adaptive Server Anywhere provider, you can get full access to Adaptive Server Anywhere features from OLE DB programming environments.
Supported platforms
Distributed transactions