ODBC client API processing

Figure 6-2 shows the interaction between an ODBC client application and the DirectConnect server.

Figure 6-2: ODBC client API example

Sybase provides a DirectConnect ODBC driver that allows ODBC applications to access data through DirectConnect.

The ODBC API processing flow consists of these steps:

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.
The ODBC application builds and executes the request using the SQLExecDirect function. This initiates a language event in the DirectConnect server.
The ODBC API uses SQLBindCol to assign local variables to specific columns. The SQLFetch call returns the resulting data to the application.
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.

ECDA Option for ODBC supports the use of the following text or image pointers for Microsoft SQL Server only: ct_data, ct_get_data, and ct_put_data.