ODBC Client API Processing

Use ODBC APIs to interact with the ODBC client application and the DirectConnect server.

ODBC Client API Example
Sybase provides a DirectConnect ODBC driver that allows ODBC applications to access data through DirectConnect.
The processing flow:

  1. The ODBC client application initiates a connect event to a specific access service using the SQLConnect call. The ODBC driver uses the CT-Library API.

  2. The ODBC application builds and executes the request using the SQLExecDirect function. This initiates a language event in the DirectConnect server.

  3. The ODBC API uses SQLBindCol to assign local variables to specific columns. The SQLFetch call returns the resulting data to the application.

  4. The ODBC API terminates the request with a SQLDisconnect call. This initiates a disconnect event in the DirectConnect server.

Procedure calls for the ODBC API are described in the Microsoft ODBC 3.5 Programmers Reference and SDK Guide.

Note: ECDA Option for ODBC supports the use of text or image pointers for Microsoft SQL Server only, such as: ct_data, ct_get_data, and ct_put_data.
Parent topic: Request Processing Flow