ODBC Conformance

ODBC drivers manufactured by different vendors may vary widely in the functions they provide. SAP 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.

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

Level 2 conformance
All level 2 features, except:
  • Three-part names of tables and views. This is not applicable for SAP 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 SAP 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 at: http://msdn.microsoft.com/en-us/library/windows/desktop/ms714177(v=vs.85).aspx.
Related concepts
Installing ODBC Drivers
Using UNIX or Linux–Based Query Tools Through ODBC
Command Line Connections to 32-bit Applications
Related tasks
Creating an ODBC Data Source
Adding ODBC Data Source Names on 64-bit Windows Systems