Connection parameters are included in connection strings.
You can enter connection parameters in:
- An application's connection string
- An ODBC data source
- The Sybase IQ Connect dialog
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.