ASA Database Administration Guide
Connecting to a Database
The following table lists the Adaptive Server Anywhere connection parameters.
For more information about each of these connection parameters, see Connection and Communication Parameters. For character set issues in connection strings, see Connection strings and character sets.
* Verbose form of keyword not used by ODBC connection parameters
Boolean values Boolean (true or false) arguments are either YES, ON, 1, or TRUE if true, or NO, OFF, 0, or FALSE if false.
Case sensitivity Connection parameters are case insensitive.
The connection parameters used by the interface library can be obtained from the following places (in order of precedence):
Connection string You can pass parameters explicitly in the connection string.
SQLCONNECT environment variable The SQLCONNECT environment variable can store connection parameters.
Data sources ODBC data sources can store parameters.
Character set restrictions The server name must be composed of the ASCII character set in the range 1 to 127. There is no such limitation on other parameters.
For more information on the character set issues, see Connection strings and character sets.
Priority The following rules govern the priority of parameters:
The entries in a connect 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 data source or file data source 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.