When connecting to Sybase IQ using Open Client or when using the INSERT...LOCATION syntax, you can set various Open Client configuration parameters in an Open Client runtime configuration (.cfg) file. For example, you can change the maximum default number of connections, which is controlled by the value of the CS_MAX_CONNECT option.
The application name for INSERT...LOCATION is Sybase IQ.
(The space between the words is required.) This application name
is set at the Open Client connection level, not at the Open Client
context level. For details about using an Open Client runtime configuration
file and the options available, see the Open Client Client-Library
C Reference Manual.
To have the .cfg take effect, stop and restart the Sybase IQ server. You may also specify certain configuration parameters in the INSERT...LOCATION command line. Parameters set in INSERT...LOCATION are superseded by parameters set in the configuration file.
When used as a remote server, Sybase IQ supports Tabular Data Steam (TDS) password encryption. The Sybase IQ server accepts a connection with an encrypted password sent by the client. For information on connection properties to set for password encryption, see “Client-Library Topics > Security features > Adaptive Server Enterprise security features > Security handshaking: encrypted password” in the Open Server 15.5 Open Client Client-Library/C Reference Manual.
Password encryption requires Open Client 15.0. TDS password encryption
requires Open Client 15.0 ESD #7 or later.
To enable the Sybase IQ server to accept a jConnect connection with an encrypted password, set the jConnect ENCRYPT_PASSWORD connection property to true.
