Connecting using ODBC

Open Database Connectivity (ODBC) is a standard API developed by Microsoft that allows a single application to access a variety of data sources for which ODBC–compliant drivers exist. ODBC 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 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: 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 requests and queries.

Conformance level

Sybase IQ support

Core conformance

All core 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:

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 requests and 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.