Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere ODBC API


Introduction to ODBC

The Open Database Connectivity (ODBC) interface is an application programming interface defined by Microsoft Corporation as a standard interface to database management systems on Windows operating systems. ODBC is a call-based interface.

To write ODBC applications for SQL Anywhere, you need:

  • SQL Anywhere.

  • A C compiler capable of creating programs for your environment.

  • The Microsoft ODBC Software Development Kit. This is available on the Microsoft Developer Network, and provides documentation and additional tools for testing ODBC applications.

Supported platforms

SQL Anywhere supports the ODBC API on Unix and Windows Mobile, in addition to Windows. Having multi-platform ODBC support makes portable database application development much easier.

For information about enlisting the ODBC driver in distributed transactions, see Three-tier computing and distributed transactions.

See also

Some application development tools that already have ODBC support provide their own programming interface that hides the ODBC interface. The SQL Anywhere documentation does not describe how to use those tools.

ODBC conformance