Connection Parameters

Connection parameters are included in connection strings.

You can enter connection parameters in:

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 check boxes 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 the circumstances under which the parameter. Common usage entries include:

  • Embedded databases – when SAP 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 SAP 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 YES, ON, 1, or TRUE if true; or NO, OFF, 0, or FALSE if false.

You can obtain the connection parameters used by the interface library from these 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.

These 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.

Parent topic: Appendix: Connection and Communication Parameters Reference