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. While it has been possible to access Sybase IQ via OLE DB using an OLE DB/ODBC bridge provided by Microsoft, this release of Sybase IQ includes an OLE DB provider. If you use the Sybase IQ OLE DB provider, ODBC is not required in your deployment.
OLE DB requires a Windows client. However, you can access both Windows and UNIX servers using OLE DB. For more information, see Adaptive Server Anywhere Programming Interfaces Guide.
Sybase IQ support for certain features used with OLE DB differs from Adaptive Server Anywhere support. Be aware of these differences when using the Anywhere documentation:
Sybase IQ does not support Windows CE.
Sybase IQ does not support remote updates through a cursor.
Sybase IQ supports Dynamic (dynamic scroll), Static (insensitive), and and Forward only (no-scroll) cursors, but does not support Keyset (scroll) cursors.
In Sybase IQ the isolation level is always 3, no matter what you specify.
For information on connecting to a database using OLE DB, see Sybase IQ System Administration Guide.
