Connecting to a running database on another computer (dbsrv12) (Command line)

To connect to a database that is currently running on a network database server, you can use the Host connection parameter.

Prerequisites

A running database on another computer.

Context and remarks

Many.

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

Run the following command (replace my_host with the host name of the computer running the network server):

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

Note

Your computer may be running software that has an embedded SQL Anywhere server, in which case there could be multiple servers running without you realizing it. You should always specify the server name (ServerName=server-name).

Results

The application connects to the database.

Next

None.