Filter
Top Products
Client/server interfaces to Adaptive Server IQ
482
Open Clients and
Open Servers
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.
Programming
Interfaces and
application protocols
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.
Tabular Data Stream
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).