ODBC conformance

SQL Anywhere provides support for ODBC 3.5, which is supplied as part of the Microsoft Data Access Kit 2.7.

SQL Anywhere supports the ODBC 3.5 specification as follows:

Core conformance SQL Anywhere supports all Core level features.
Level 1 conformance SQL Anywhere supports all Level 1 features, except for asynchronous execution of ODBC functions.
SQL Anywhere supports multiple threads sharing a single connection. The requests from the different threads are serialized by SQL Anywhere.
Level 2 conformance SQL Anywhere supports all Level 2 features, except for the following ones:
- Three part names of tables and views. This is not applicable for SQL Anywhere.
- Asynchronous execution of ODBC functions for specified individual statements.
- Ability to time out login requests and SQL queries.

Discuss this page in DocCommentXchange.