ODBC Programming

Open Database Connectivity (ODBC) is a programming interface for developing applications to access data from database management systems.

The primary documentation for ODBC application development is the Microsoft ODBC SDK documentation at http://msdn.microsoft.com. The introductory material and feature descriptions specific to Adaptive Server® Enterprise ODBC Driver are provided, but is not a complete guide to ODBC application programming.

• ODBC Requirements and Supported Platforms
  The ODBC interface is a call-based application programming interface defined by Microsoft Corporation as a standard interface to database management systems on Microsoft Windows.
• ODBC Conformance
  The Adaptive Server ODBC Driver conforms to ODBC 3.52 specification.
• ODBC Driver Manager
  The ODBC Driver Manager manages the communications between the user applications and the ODBC drivers.
• Adaptive Server ODBC Driver Samples
  Review the Adaptive Server ODBC Driver samples for Windows and UNIX platforms.
• ODBC Handles
  ODBC applications use a small set of handles to define basic features, such as database connections and SQL statements.
• Connections to a Datasource
  Use ODBC functions to establish a connection to an Adaptive Server Enterprise database.
• SQL Statements Execution
  ODBC includes several functions for executing SQL statements.
• Result Sets
  ODBC applications use cursors to manipulate and update result sets. The Adaptive Server ODBC Driver provides extensive support for different kinds of cursors and cursor operations.
• Calling Stored Procedures
  Create and call stored procedures to process the results from an ODBC application.
• Error Handling
  Errors in ODBC are reported using the return value from each of the ODBC function calls and either the SQLGetDiagField function or the SQLGetDiagRec function.
• Datatype Mappings
  The Adaptive Server ODBC Driver datatype mappings.