Connection parameters are included in connection strings. They can be entered in the following places:
In an application's connection string. See Assembling a list of connection parameters and Connection parameters passed as connection strings.
SQLConnect environment variable.
In an ODBC data source. See ODBC data sources.
In the SQL Anywhere Connect window. See SQL Anywhere utilities connections.
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 demo12 is running the sample database (which can be started with the command
dbeng12 "%SQLANYSAMP12%\demo.db"
). The following command returns a message indicating that the connection to the database was successful.
dbping -d -c "Server=demo12;DBN=demo;UID=DBA;PWD=sql" |
The following command returns the message Ping database failed - Database server not running
if no database server named other-server is running on the local computer:
dbping -c "Server=other-server" |
AppInfo (APP) connection parameter
AutoStart (ASTART) connection parameter
AutoStop (ASTOP) connection parameter
CharSet (CS) connection parameter
CommBufferSize (CBSIZE) connection parameter
CommLinks (LINKS) connection parameter
Compress (COMP) connection parameter
CompressionThreshold (COMPTH) connection parameter
ConnectionName (CON) connection parameter
ConnectionPool (CPOOL) connection parameter
DatabaseFile (DBF) connection parameter
DatabaseKey (DBKEY) connection parameter
DatabaseName (DBN) connection parameter
DatabaseSwitches (DBS) connection parameter
DataSourceName (DSN) connection parameter
DisableMultiRowFetch (DMRF) connection parameter
Elevate connection parameter
EncryptedPassword (ENP) connection parameter
Encryption (ENC) connection parameter
EngineName (ENG) connection parameter (deprecated)
FileDataSourceName (FILEDSN) connection parameter
ForceStart (FORCE) connection parameter
Host connection parameter
Idle connection parameter
Integrated (INT) connection parameter
Kerberos (KRB) connection parameter
Language (LANG) connection parameter
LazyClose (LCLOSE) connection parameter
LivenessTimeout (LTO) connection parameter
LogFile (LOG) connection parameter
NewPassword (NEWPWD) connection parameter
MatView (MATVIEW) connection parameter
NodeType (NODE) connection parameter
Password (PWD) connection parameter
PrefetchBuffer (PBUF) connection parameter
PrefetchOnOpen connection parameter
PrefetchRows (PROWS) connection parameter
RetryConnectionTimeout (RetryConnTO) connection parameter
ServerName (Server) connection parameter
StartLine (START) connection parameter
Unconditional (UNC) connection parameter
Userid (UID) connection parameter
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |