Contents Index Connecting from ADO Connection parameter tips

ASA Database Administration Guide
  Connecting to a Database

Connection parameters


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.

Parameter Short form Argument
AppInfo connection parameter [APP] APP String
AutoStart connection parameter [ASTART] ASTART Boolean
AutoStop connection parameter [ASTOP] ASTOP Boolean
CharSet connection parameter [CS] CS String
CommBufferSize connection parameter [CBSIZE] CBSIZE Integer
CommLinks connection parameter [LINKS] LINKS String
Compress connection parameter [COMP] COMP String
CompressionThreshold connection parameter [COMPTH] COMPTH Integer
ConnectionName connection parameter [CON] CON String
DatabaseFile connection parameter [DBF] DBF String
DatabaseName connection parameter [DBN] DBN String
DatabaseSwitches connection parameter [DBS] DBS String
DataSourceName connection parameter [DSN] DSN String
DisableMultiRowFetch connection parameter [DMRF] DMRF Boolean
EncryptedPassword connection parameter [ENP] ENP Encrypted string
Encryption connection parameter [ENC] ENC String
EngineName connection parameter [ENG] / ServerName connection parameter [ENG] ENG String
FileDataSourceName connection parameter [FILEDSN] FILEDSN String
ForceStart connection parameter [FORCESTART] FORCE Boolean
Idle connection parameter [IDLE] IDLE Integer
Integrated connection parameter [INT] INT Boolean
LazyClose connection parameter [LCLOSE] LCLOSE Boolean
LivenessTimeout connection parameter [LTO] LTO Integer
Logfile connection parameter [LOG] LOG String
Password connection parameter [PWD] * PWD String
PrefetchBuffer connection parameter [PBUF] PBUF Integer
PrefetchRows connection parameter [PROWS] PROWS Integer
StartLine connection parameter [START] START String
Unconditional connection parameter [UNC] UNC Boolean
Userid connection parameter [UID] * UID String

* Verbose form of keyword not used by ODBC connection parameters

Notes 

Connection parameter tips

Contents Index Connecting from ADO Connection parameter tips