Connecting to a running database on another computer (command line)

You can connect to a database running on a network database server by using the Interactive SQL utility at a command prompt and the Host connection parameter.

Prerequisites

There must be a running database on another computer.

Task

Run the following command:

dbisql -c "UID=user-ID;PWD=password;ServerName=server-name;Host=host-name"

Note

Since a computer system can run multiple SQL Anywhere database servers, always specify the database server name (ServerName=server-name) when connecting to a database.

Results

The application connects to the database.

Example

Run the following command to connect to the sample database on the host my_host:

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