When 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: 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 SQL Anywhere Server - Database Administration
> Replication > Using SQL Anywhere as an Open Server > Setting up
SQL Anywhere as an Open Server > Characteristics of Open Client and jConnect
connections.
Note: This reference points to SQL Anywhere documentation.
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.
See Reference: Statements and Options > Database Options > Alphabetical List of Options > LOGIN_PROCEDURE Option.