Connection parameters

Connection parameters are included in connection strings. They can be entered in the following places:

The ODBC Configuration For SQL Anywhere 11 window and the SQL Anywhere Connect window for Windows operating systems share a common format. Some of the parameters correspond to checkboxes and fields in these windows, while others can be entered in the text box on the Advanced tab.

Notes
  • Connection parameters are case insensitive, although their values may not be (for example, file names on Unix).
  • Boolean parameters are turned on with YES, Y, ON, TRUE, T, or 1, and are turned off with any of NO, N, OFF, FALSE, F, and 0. The 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 SQL 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 a SQL Anywhere personal server is already running, and the database is already loaded on the server.

    • Network servers   When SQL 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. The -c option is used to specify the connection parameters. For example, suppose a personal server with the name demo11 is running the sample database (which can be started with the command dbeng11 samples-dir\demo.db). The following string returns the message Ping database successful if a database server named demo11 is running on the local computer and has a database named demo running:

    dbping -d -c "ENG=demo11;DBN=demo;UID=DBA;PWD=sql"

    The following command, however, returns the message Ping database failed - Database server not running if no database server named other-server is running on the local computer:

    dbping -d -c "ENG=other-server;UID=DBA;PWD=sql"

    See Ping utility (dbping).

See also

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]
DatabaseKey connection parameter [DBKEY]
DatabaseName connection parameter [DBN]
DatabaseSwitches connection parameter [DBS]
DataSourceName connection parameter [DSN]
DisableMultiRowFetch connection parameter [DMRF]
Elevate connection parameter
EncryptedPassword connection parameter [ENP]
Encryption connection parameter [ENC]
EngineName connection parameter [ENG]
FileDataSourceName connection parameter [FILEDSN]
ForceStart connection parameter [FORCE]
Idle connection parameter
Integrated connection parameter [INT]
Kerberos connection parameter [KRB]
Language connection parameter [LANG]
LazyClose connection parameter [LCLOSE]
LivenessTimeout connection parameter [LTO]
LogFile connection parameter [LOG]
NewPassword connection parameter [NEWPWD]
Password connection parameter [PWD]
PrefetchBuffer connection parameter [PBUF]
PrefetchOnOpen connection parameter
PrefetchRows connection parameter [PROWS]
RetryConnectionTimeout connection parameter [RetryConnTO]
ServerName connection parameter [ENG]
StartLine connection parameter [START]
Unconditional connection parameter [UNC]
Userid connection parameter [UID]