Request processing flow  CT-Library client API processing

Chapter 5: Managing Transactions

ODBC client API processing

Sybase provides a DirectConnect ODBC driver that allows ODBC applications to access data through DirectConnect. The following figure shows the interaction between an ODBC client application and DirectConnect.

Figure 5-2: ODBC client API example

The ODBC API processing flow includes the following steps:

  1. The ODBC client application initiates a connect event to a specific DirectConnect 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 Programmer’s Reference and SDK Guide.




Copyright © 2005. Sybase Inc. All rights reserved. CT-Library client API processing

View this book as PDF