Sybase IQ supports ODBC 3.5.2.
ODBC drivers manufactured by different vendors may vary widely in the functions they provide. ODBC features are arranged according to a level of conformance. Features are either Core, Level 1, or Level 2, with level 2 being the most complete level of ODBC support. These features are listed in the ODBC Programmer's Reference, which is available from Microsoft Corporation as part of the ODBC software development kit or from the Microsoft Web site. Using your browser, go to the Microsoft Web site.
Sybase IQ ODBC 3.5.2 support is as follows:
Core conformance Sybase IQ supports all Core level features.
Level 1 conformance Sybase IQ supports 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 Sybase IQ supports 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.
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.
