Sybase 12.4.2 manual Client/server interfaces to Adaptive Server IQ, 482

Client/server interfaces to Adaptive Server IQ

Open Clients and Open Servers

Programming

Interfaces and application protocols

Tabular Data Stream

Members of the Adaptive Server family act as Open Servers. Client applications communicate with Open Servers using the Open Client libraries available from Sybase. Open Client includes both the Client Library (CT- Library) and the older DB-Library interfaces. Adaptive Server IQ can also act as an Open Server, but in order to use the Open Client libraries, the client application must use only the supported system tables, views and stored procedures. See Appendix A, “Transact-SQL Compatibility,” in Adaptive Server IQ Reference Manual for a list of compatible syntax.

The following figure shows how client applications communicate with an Adaptive Server IQ. In Adaptive Server IQ 12, you do not need to install Open Client libraries, and you can connect through either ODBC or JDBC. This contrasts with Adaptive Server IQ 11.5 and earlier, which required separate Open Client libraries, and did not support JDBC.

Adaptive Server IQ supports two application protocols:

•An application protocol specific to Adaptive Server IQ and Adaptive Server Anywhere is used for ODBC, JDBC, and Embedded SQL applications.

•TDS ( tabular data stream) is used for JDBC connections, Open Client applications and for other Sybase applications such as OmniConnect.

Open Clients and Open Servers exchange information using the TDS application protocol. All applications built using the Sybase Open Client libraries are also TDS applications, because the Open Client libraries handle the TDS interface. However, some applications (such as Sybase jConnect) are TDS applications even though they do not use the Sybase Open Client libraries (they communicate directly to the TDS layer).

482