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

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:

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

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