Using the Open Client interface, you can use a SQL Anywhere database in much the same way as you would an Adaptive Server Enterprise database. There are some limitations, including the following:
Commit Service SQL Anywhere does not support the Adaptive Server Enterprise Commit Service.
Capabilities A client/server connection's capabilities determine the types of client requests and server responses permitted for that connection. The following capabilities are not supported:
Security options, such as SSL and encrypted passwords, are not supported.
Open Client applications can connect to SQL Anywhere using TCP/IP.
For more information on capabilities, see the Open Server Server-Library C Reference Manual.
When the CS_DATAFMT is used with the CS_DESCRIBE_INPUT, it does not return the data type of a column when a parameterized variable is sent to SQL Anywhere as input.