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.
Sybase IQ includes an OLE DB provider. If you use the Sybase IQ OLE DB provider, ODBC is not required.
OLE DB requires a Windows client. However, you can access both Windows and UNIX servers using OLE DB.
For more information, see the SQL Anywhere Server Programming Guide and “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.
