Programming interfaces in adaptive Server anywhere

Adaptive Server Anywhere supports a variety of programming interfaces, making you more flexible when working with various types of application and application development environments.

Supported interfaces and protocols

The following illustration shows the supported interfaces and the interface libraries used. In most cases, the interface library has the same name as the interface itself.

Applications that are provided with SQL Anywhere Studio use several of the following interfaces:

Communication protocol

Each interface library uses the communication Protocol communication protocol anywhere to support two communication protocols: Tabular data streaming tabular data (tabular, TDS), and command sequence command sequences. These two protocols are inherent, and for most purposes, it does not matter which protocol you use. The development environment that you choose will be controlled by the available tools. The main difference you will see is the connection to the database. The command sequence application and the TDS application use different methods to identify the database and the database server, so the Connection dialog box is different.

Tds

This protocol is used by Sybase adaptive Server Enterprise, Open Client applications, and Java applications that use JConnect JDBC driver connections through TDS.

Command sequence This protocol is used by adaptive server Anywhere, Adaptive Server IQ, and is used by embedded SQL, ODBC, and OLE DB applications.