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

SQL Anywhere 12.0.1 » SQL Anywhere 12 - Introduction » Data management technologies » Programming interfaces


Interface library communication 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 parameters are different.

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

  • TDS   This protocol is used by Sybase Adaptive Server Enterprise, the jConnect JDBC driver, and Sybase Open Client applications. For more information about TDS, see SQL Anywhere as an Open Server.