Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere 11 - Introduction » SQL Anywhere 11 Overview » Overview of data management technologies » Programming interfaces


Communications protocols

Each interface library communicates with the database server using a communication protocol. SQL Anywhere supports two communication protocols, Command Sequence and Tabular Data Stream (TDS). These protocols are internal, and for most purposes it does not matter which one you are using. Your choice of development environment will be governed by your available tools.

The major differences are visible when connecting to the database. Command Sequence applications and TDS applications use different methods to identify a database and database server, and so connection windows are different.

Command Sequence   This protocol is used by SQL Anywhere, the iAnywhere JDBC driver, and the embedded SQL, ODBC, OLE DB, and ADO.NET APIs.

TDS   This protocol is used by Sybase Adaptive Server Enterprise, Open Client applications, and Java applications that use the jConnect JDBC driver connect using TDS.