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.

NoteNotes