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 on enlisting the ODBC driver in distributed transactions, see Three-tier computing and distributed transactions.

See also
Note

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

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