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.
SAP Sybase IQ includes an OLE DB provider named SAOLEDB. This provider is available for current Windows platforms. The provider is not available for Windows Mobile platforms.
You can also access SAP Sybase IQ using the Microsoft OLE DB Provider for ODBC (MSDASQL), together with the SQL Anywhere ODBC driver.
Using the SAP Sybase IQOLE 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 SAP Sybase IQ 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 SAP Sybase IQprovider, you can get full access to SAP Sybase IQ features from OLE DB programming environments.