ASA Programming Guide
ODBC Programming
Introduction to ODBC
Adaptive Server Anywhere provides support for ODBC 3.5, which is supplied as part of the Microsoft Data Access Kit 2.7.
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 ODBC Programmer's Reference, which is available from Microsoft Corporation as part of the ODBC software development kit or from the Microsoft Web site, at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch21bpr_2.asp.
Adaptive Server Anywhere supports the ODBC 3.5 specification.
Core conformance Adaptive Server Anywhere supports all Core level features.
Level 1 conformance Adaptive Server Anywhere supports all Level 1 features, except for asynchronous execution of ODBC functions.
Adaptive Server Anywhere supports multiple threads sharing a single connection. The requests from the different threads are serialized by Adaptive Server Anywhere.
Level 2 conformance Adaptive Server Anywhere supports all Level 2 features, except for the following:
Three part names of tables and views. This is not applicable for Adaptive Server Anywhere.
Asynchronous execution of ODBC functions for specified individual statements.
Ability to time out login request and SQL queries.
Applications developed using older versions of ODBC continue to work with Adaptive Server Anywhere and the newer ODBC Driver Manager. The new ODBC features are not provided for older applications.
The ODBC Driver Manager is part of the ODBC software supplied with Adaptive Server Anywhere. The ODBC Version 3 Driver Manager has a new interface for configuring ODBC data sources.