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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Introduction » Overview of Data Management Technologies » Programming interfaces

Programming interfaces Next Page

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. The Command Sequence applications and TDS applications use different methods to identify a database and database server, and so connection dialogs 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.