Open Client and jConnect Connections

When SAP Sybase IQ serves applications over TDS, it automatically sets relevant database options to values that are compatible with SQL Anywhere Server default behavior. These options are set temporarily, for the duration of the connection only. The client application can override these options at any time.

Note:

SAP Sybase IQ does not support the ANSI_BLANKS, FLOAT_AS_DOUBLE, and TSQL_HEX_CONSTANT options.

Although SAP Sybase IQ allows longer user names and passwords, TDS client user names and passwords cannot exceed 30 bytes. If your password or user ID is longer than 30 bytes, attempts to connect over TDS (for example, using jConnect) return an Invalid user ID or password error.

Note: ODBC applications, including Interactive SQL applications, automatically set certain database options to values mandated by the ODBC specification. This overwrites settings by the LOGIN_PROCEDURE database option.
Parent topic: SAP Sybase IQ as a Data Server for Client Applications
Related concepts
Characteristics of Sybase Open Client and jConnect connections