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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming

 

ODBC support

ODBC (Open Database Connectivity) is a standard call level interface (CLI) developed by Microsoft Corporation. It is based on the SQL Access Group CLI specification. ODBC applications can run against any data source that provides an ODBC driver. ODBC is a good choice for a programming interface if you want your application to be portable to other data sources that have ODBC drivers.

ODBC is a low-level interface. Almost all the SQL Anywhere functionality is available with this interface. ODBC is available as a DLL under Windows operating systems. It is provided as a shared object library for Unix.

The core documentation for the ODBC API can be found on the Microsoft Developer Network website at [external link] http://msdn.microsoft.com/en-us/library/ms710252.aspx.


Requirements for developing ODBC applications
ODBC application development
ODBC samples
ODBC handles
ODBC connection functions
Server options changed by ODBC
SQLSetConnectAttr extended connection attributes
Considerations for the Windows DllMain function
Ways to execute SQL statements
64-bit ODBC considerations
Data alignment requirements
Result sets in ODBC applications
Stored procedure considerations
ODBC escape syntax
Error handling in ODBC