Connection Parameters

Connection parameters are included in connection strings.

You can enter connection parameters in the following places:

After each parameter name, the short form appears in square brackets. You can use the short form as an abbreviation in connect commands.

The ODBC configuration dialog and the Sybase IQ Connect dialog for Windows operating systems share a common format. Some parameters correspond to checkboxes and fields in these dialogs, while others can be entered in the text box on the Advanced tab.

Usage Notes

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.

  • 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 the Utility Guide > dbping Database Administration Utility.

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.

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.

Related concepts
Connections from ADO