Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database connections

Connection parameters and connection strings

When connecting to a database, the client application uses a set of connection parameters and connection strings to define the connection.

Connection parameters specify information such as the database server name, the database name, and the user ID.

Each connection parameter specifies a keyword-value pair of the form parameter=value. The following example specifies the password connection parameter PWD:

PWD=passwd
Connection parameters passed as connection strings

Connection parameters are assembled into connection strings. In a connection string, a semicolon separates each connection parameter:

parameter1=value1;parameter2=value2;...

For example:

UID=DBA;PWD=passwd;Host=myhost;DatabaseName=mydemo;ServerName=myserver

Generally, the connection string that is built by an application and passed to the interface library does not correspond directly to the way users enter information. Instead, a user may fill in multiple fields in a connection window, or the application may read connection information from an initialization file.

Many utilities accept a connection string as the -c option and pass the connection string unchanged to the interface library. The following example is a typical Backup utility (dbbackup) command line:

dbbackup -c "HOST=myhost-pc;DBN=mydemo;UID=DBA;PWD=passwd;ServerName=myserver" SQLAnybackup

In your application, you must enter a connection string with the parameter settings separated by semicolons.