ODBC Conformance

ODBC drivers manufactured by different vendors may vary widely in the functions they provide. Sybase IQ supports ODBC 3.5.2.

ODBC Conformance Levels.

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.

Note:
  • 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.

Related concepts
Installing ODBC Drivers
Using UNIX or Linux–Based Query Tools Through ODBC
Command Line Connections to 32-bit Applications
Related reference
Managing ODBC Data Sources