OLE DB uses the Component Object Model (COM) to make data from a variety of sources available to applications. Relational databases are among the classes of data sources that you can access through OLE DB.
This section describes how to connect to a Sybase IQ database using OLE DB from the following environments:
Sybase PowerBuilder® can access OLE DB data sources, and you can use Sybase IQ as a PowerBuilder OLE DB database profile.
Microsoft ActiveX Data Objects (ADO) provides a programming interface for OLE DB data sources. You can access Sybase IQ from programming tools such as Microsoft Visual Basic.
OLE DB requires a Windows client. However, you can access both Windows and UNIX servers using OLE DB.
This section is an introduction to how to use OLE DB from Sybase PowerBuilder and Microsoft ADO environments such as Visual Basic. It is not complete documentation on how to program using ADO or OLE DB. The primary source of information on development topics is your development tool documentation.
For more information about OLE DB, see SQL Anywhere Server – Programming.
Sybase IQ support for certain features used with OLE
DB differs from the support of SQL Anywhere:
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.
