ASA Database Administration Guide
Connection and Communication Parameters
This section describes each connection parameter. Connection parameters are included in connection strings. They can be entered in the following places:
In an application's connection string.
For more information, see Assembling a list of connection parameters.
In an ODBC data source.
For more information, see Working with ODBC data sources.
In the Adaptive Server Anywhere Connect dialog.
For more information, see Connecting from Adaptive Server Anywhere utilities.
The ODBC configuration dialog and the Adaptive Server Anywhere 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 at the end on the Advanced tab.
Connection parameters are case insensitive.
The Usage for each connection parameter describes the circumstances under which the parameter is to be used. Common usage entries include the following:
Embedded databases When Adaptive Server Anywhere is used as an embedded database, the connection starts a personal server and loads the database. When the application disconnects from the database, the database is unloaded and the server stops.
Running local databases This refers to the case where an Adaptive Server Anywhere personal server is already running, and the database is already loaded on the server.
Network servers When Adaptive Server Anywhere is used as a network server, the client application must locate a server already running somewhere on the network and connect to a database.
You can use the dbping utility to test connection strings. For example, if a personal server with the name asademo is running the database asademo (which can be started with the command "dbeng9 asademo.db")
The following string returns the message Ping database successful
:
dbping -d -c "eng=asademo;dbn=asademo;uid=db;pwd=sql"
The following command, however, returns the message Ping database failed - Database server not running
:
dbping -d -c "eng=other_engine;uid=dba;pwd=sql"
For more information, see The Ping utility.
AppInfo connection parameter [APP]
AutoStart connection parameter [ASTART]
AutoStop connection parameter [ASTOP]
CharSet connection parameter [CS]
CommBufferSize connection parameter [CBSIZE]
CommLinks connection parameter [LINKS]
Compress connection parameter [COMP]
CompressionThreshold connection parameter [COMPTH]
ConnectionName connection parameter [CON]
DatabaseFile connection parameter [DBF]
DatabaseName connection parameter [DBN]
DatabaseSwitches connection parameter [DBS]
DataSourceName connection parameter [DSN]
DisableMultiRowFetch connection parameter [DMRF]
EngineName connection parameter [ENG]
EncryptedPassword connection parameter [ENP]
Encryption connection parameter [ENC]
Encryption Key connection parameter [DBKEY]
FileDataSourceName connection parameter [FILEDSN]
ForceStart connection parameter [FORCESTART]
Idle connection parameter [IDLE]
Integrated connection parameter [INT]
Language [LANG]
LazyClose connection parameter [LCLOSE]
LivenessTimeout connection parameter [LTO]
Logfile connection parameter [LOG]
Password connection parameter [PWD]
PrefetchBuffer connection parameter [PBUF]
PrefetchRows connection parameter [PROWS]
ServerName connection parameter [ENG]
StartLine connection parameter [START]
Unconditional connection parameter [UNC]
Userid connection parameter [UID]