Common connection scenarios

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 client application is running on the same computer as the database server.

Note

A single computer can run multiple database servers at the same time. For this reason, it is recommended that you always specify the database server name (ServerName=server-name) when authenticating to a database server.

Each database server can run multiple databases at the same time. For this reason, it is recommended that you always specify the database name (DatabaseName=database-name) when authenticating to a database server.

The following tables contain 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. In addition to those listed below, SQL Anywhere supports many connection parameters to handle less common connection scenarios.

Shared memory connections to local servers

An X in the following table indicates a required connection parameter for the scenario listed at the top of the column.

Connection parameter	1 server hosting 1 database	1 server hosting many databases	Many servers each hosting 1 database	Many servers each hosting many databases
UserID (UID)	X	X	X	X
Password (PWD)	X	X	X	X
DatabaseName (DBN)		X		X
ServerName(Server)	¹	¹	X	X
Host ²	¹	¹

¹ Include the server name (ServerName=server-name) if the server is running with the -xd option.

² When the Host connection parameter (Host=host-name:port-number) is used, the connection is attempted using TCP/IP rather than shared memory. This option is inappropriate for the personal database server unless the TCP/IP communication protocol was enabled on the personal database server using the -x option. Also, you must use the host name localhost when connecting to a personal database server using TCP/IP.

Connections to network servers

An X in the following table indicates a required connection parameter for the scenario listed at the top of the column.

Connection parameter	1 server hosting 1 database	1 server hosting many databases	Many servers each hosting 1 database	Many servers each hosting many databases
UserID (UID)	X	X	X	X
Password (PWD)	X	X	X	X
DatabaseName (DBN)		X		X
ServerName(Server)	³	³	X	X
Host	X³	X³	X	X

³ Include the port number (Host=host-name:port-number) or the server name (ServerName=server-name) if the server is not running on the default TCP/IP port (2638). If the database server with the non-default port number is on Mac OS X or if it was started using the -sb option then you must specify the port number (Host=host-name:port-number) to connect.

Examples

Only one database server running only one database, running on the same computer as the client application
dbisql -c "UID=DBA;PWD=sql"
Only one database server running multiple databases, running on the same computer as the client application
dbisql -c "UID=DBA;PWD=sql;DBN=demo"

Multiple database servers each running one database, running on the same computer as the client application

dbisql -c "UID=DBA;PWD=sql;ServerName=demo16"

Multiple database servers each running several databases, running on the same computer as the client application

dbisql -c "UID=DBA;PWD=sql;ServerName=demo16;DBN=demo"

Only one database server running only one database, running on a different computer than the client application, and the computer running the database server is named myhost-pc
dbisql -c "UID=DBA;PWD=sql;Host=myhost-pc"

Multiple database servers each running several databases, running on a different computer than the client application, and the computer running the database server is named myhost-pc

dbisql -c "UID=DBA;PWD=sql;Host=myhost-pc;ServerName=demo16;DBN=demo"

A cloud with multiple hosts, running multiple database servers each running several databases

dbisql -c "UID=DBA;PWD=sql;Host=74.125.163.214:40200,74.125.167.240:9038;DBN=demo"

You do not know if the database server or database are running and you want them started on the same computer as the client application so you can connect to it

dbisql -c "UID=DBA;PWD=sql;ServerName=demo16;DBF=%SQLANYSAMP16%\demo.db;"

Default connection parameters

Discuss this page in DocCommentXchange.

Common connection scenarios

Note

Shared memory connections to local servers

Connections to network servers

See also

Examples