When Sybase IQ is serving 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.
Sybase IQ does not support the ANSI_BLANKS, FLOAT_AS_DOUBLE,
and TSQL_HEX_CONSTANT options.
Although 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.
See ”Characteristics of Open Client and jConnect connections” in SQL Anywhere Server - Database Administration.
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.
For details and a workaround, see “LOGIN_PROCEDURE
option” in Reference: Statements and Options.
