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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connecting to a database » Introduction to SQL Anywhere database connections

 

How connection parameters work

When an application connects to a database, it uses a set of connection parameters to define the connection. Connection parameters include information such as the server name, the database name, and a user ID.

A keyword-value pair (of the form parameter=value) specifies each connection parameter. For example, you specify the password connection parameter for the default password as follows:

Password=sql

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

ServerName=demo11;DatabaseName=demo
Representing connection strings

Connection string examples can be represented in the following form:

parameter1=value1
parameter2=value2
...

This is equivalent to the following connection string:

parameter1=value1;parameter2=value2

You must enter a connection string on a single line with the parameter settings separated by semicolons.