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 SQL Anywhere Server Programming Guide. For information on connecting to a database using OLE DB, see ”Connecting to a database using OLE DB” in Chapter 3, “Sybase IQ Connections,” in the Sybase IQ System Administration Guide.
Sybase IQ support for certain features used with OLE
DB differs from SQL Anywhere support. Be aware of these differences
when using the SQL 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 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.
