![AppInfo connection parameter [App]](arrow-right.gif){kind=icon}
This section describes each connection parameter. After each parameter name, the short form is listed in square brackets. You can use the short form as an abbreviation in connect commands.
Connection parameters are included in connection strings. They can be entered in the following places:
In an application's connection string
In an ODBC data source
In the Sybase IQ Connect dialog
For more information see Chapter 3, “Sybase IQ Connections.”
The ODBC configuration dialog and the Sybase IQ Connect dialog for Windows operating systems share a common format. Some of the parameters correspond to checkboxes and fields in these dialogs, while others can be entered in the text box on the Advanced tab.
Connection parameters are case insensitive.
The Usage for each connection parameter describes circumstances under which the parameter is to be used. Common usage entries include the following:
Embedded databases When Sybase IQ is used as an embedded database, the connection starts a server and loads the database. When the application disconnects from the database, the database is unloaded and the server stops. For more information on embedded databases, see “Simple connection examples”.
Network servers When Sybase IQ is used as a network server, the client application must locate a server already running on the network and connect to a database.
You can use the dbping utility to test connection strings. For examples, see “Ping utility (dbping)” in the Utility Guide.
Boolean (true or false) arguments are either YES, ON, 1, or TRUE if true, or NO, OFF, 0, or FALSE if false.
The connection parameters used by the interface library can be obtained from the following places (in order of precedence):
Connection string
SQLCONNECT environment variable
Data sources
The server name must be composed of characters in the range 1 to 127 of the ASCII character set. There is no such limitation on other parameters. For more information on the character set issues, see “Connection strings and character sets”.
The following rules govern the priority of parameters:
The entries in a connection string are read left to right. If the same parameter is specified more than once, the last one in the string applies.
If a string contains a DSN or FILEDSN entry, the profile is read from the configuration file, and the entries from the file are used if they are not already set. For example, if a connection string contains a data source name and sets some of the parameters contained in the data source explicitly, then in case of conflict the explicit parameters are used.
