Connecting Using OLE DB

Sybase IQ includes an OLE DB provider as an alternative to ODBC.

OLE DB is a data access model from Microsoft that uses the Component Object Model (COM) interfaces. Unlike ODBC, OLE DB does not assume that the data source uses a SQL query processor. Although OLE DB requires a Windows client, you can use using OLE DB to access Windows and UNIX servers.

For more information, see SQL Anywhere Server - Programming and Sybase IQ System Administration Guide Volume 1 > Database Connections Using OLE DB.

Note: Sybase IQ OLE DB support differs from SQL Anywhere support.

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.

Sybase IQ does not support:
  • Windows CE.

  • Remote updates through a cursor.

Related concepts
Connecting Using JDBC
Running the Client and Server on the Same System
Connecting Using ODBC
Related tasks
Connecting Using Open Client