ODBC conformance

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

Levels of ODBC support

ODBC features are arranged according to 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 Microsoft [external link] ODBC Programmer's Reference.

Features supported by SQL Anywhere

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.

ODBC backward compatibility

Applications developed using older versions of ODBC continue to work with SQL Anywhere and the newer ODBC driver manager. The new ODBC features are not provided for older applications.

The ODBC driver manager

Microsoft Windows includes an ODBC driver manager. For Unix, an ODBC driver manager is supplied with SQL Anywhere.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0