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_FIRST
    • CS_CSR_LAST
    • CS_CSR_PREV
    • CS_CSR_REL
    • CS_DATA_BOUNDARY
    • CS_DATA_SENSITIVITY
    • CS_OPT_FORMATONLY
    • CS_PROTO_DYNPROC
    • CS_REG_NOTIF
    • 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.