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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » Sybase Open Client support


Known Open Client limitations of SQL Anywhere

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:

  • SQL Anywhere does not support the Adaptive Server Enterprise Commit Service.

  • 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:

    • CS_CSR_ABS
    • CS_CSR_REL
    • CS_REQ_BCP
  • Security options, such as SSL, are not supported. However, password encryption is supported.

  • Open Client applications can connect to SQL Anywhere using TCP/IP.

    For more information about 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.