OLE DB is a data access model from Microsoft. It uses the Component Object Model (COM) interfaces. Unlike ODBC, OLE DB does not assume that the data source uses a SQL query processor.
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 Guide. For information on connecting to a database using OLE DB, see Sybase IQ System Administration 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.
