Connecting using ODBC

Open Database Connectivity (ODBC) is a standard application programming interface (API) developed by Microsoft. It allows a single application to access a variety of data sources for which ODBC–compliant drivers exist. The application uses SQL as the standard data access language.

ODBC conformance

ODBC drivers manufactured by different vendors may vary widely in the functions they provide. Sybase IQ supports ODBC 3.5.2. ODBC 3.x, drivers are classified based on the features they provide:

Conformance Level	Sybase IQ Support
Core conformance	All Core level features.
Level 1 conformance	All Level 1 features, except for asynchronous execution of ODBC functions. Sybase IQ does support multiple threads sharing a single connection. The requests from the different threads are serialized by Sybase IQ.
Level 2 conformance	All Level 2 features, except for the following: Three-part names of tables and views. This is not applicable for Sybase IQ. Asynchronous execution of ODBC functions for specified individual statements. Ability to time out login request and SQL queries.

Conformance Level

Sybase IQ Support

Core conformance

All Core level features.

Level 1 conformance

All Level 1 features, except for asynchronous execution of ODBC functions.

Sybase IQ does support multiple threads sharing a single connection. The requests from the different threads are serialized by Sybase IQ.

Level 2 conformance

All Level 2 features, except for the following:

Three-part names of tables and views. This is not applicable for Sybase IQ.
Asynchronous execution of ODBC functions for specified individual statements.
Ability to time out login request and SQL queries.

Notes

Although you can use new ODBC 3.5.x features such as descriptors in your ODBC applications, ODBC 2.x applications will continue to work with Sybase IQ.

For more information about ODBC, see the ODBC Programmer's Reference, available from Microsoft Corporation as part of the ODBC software development kit or from the Microsoft Web site.