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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections » Using connection parameters

 

Connecting to SQL Anywhere databases

A single computer can run multiple database servers at the same time. Each database server can run multiple databases at the same time. The connection parameters required to connect to a database vary depending on whether multiple database servers are running on the same computer, whether multiple databases are running on the same database server, and whether the application is running on the same computer as the database server.

The following table describes several common connection scenarios and the client connection parameters that are required in each case. By combining these connection parameters, you can correctly identify the database you want to connect to. SQL Anywhere supports many connection parameters in addition to the ones listed below to handle less common connection scenarios.

Scenario Required connection parameters Comments See also

One database running on a single database server, all running on the same computer as the client application.

Userid (UID)

Password (PWD)

Userid (UID) connection parameter

Password (PWD) connection parameter

Database server running on a different computer than the client application.

Userid (UID)

Password (PWD)

HOST

The HOST connection parameter identifies the computer where the database server is running.

Host connection parameter

Multiple database servers running on the same computer.

Userid (UID)

Password (PWD)

ServerName (Server)

The Server connection parameter identifies the database server where the database is running. It is a good practice to always specify a server name.

ServerName (Server) connection parameter

Multiple databases running on the same database server that is only database server running on the computer.

Userid (UID)

Password (PWD)

DatabaseName (DBN)

The DBN connection parameter identifies which database you want to connect to.

DatabaseName (DBN) connection parameter

You do not know if the database is running on the database server and you want the database started so you can connect to it.

Userid (UID)

Password (PWD)

DatabaseFile (DBF)

The DBF connection parameter specifies the full path and name of the database you want to connect to, relative to the database server computer. The DBF connection parameter should specify a file on the computer where the database server is running, and it should not be a UNC file name.

DatabaseFile (DBF) connection parameter
 See also