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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections


Starting and connecting to a database on another computer (dbsrv12)

Although not recommended, you can start and connect to a database on another computer.


If a database server isn't already running, start a network database server on another computer. For example, run the following command to start the SQL Anywhere 12 Demo database:

dbsrv12 -n demo12 -gd all

Context and remarks


The following scenario is uncommon and not recommended. It assumes that the network database server was started on another computer with the -gd all option specified. See -gd dbeng12/dbsrv12 server option.

 Start and connect to a database on another computer (dbsrv12)
  • Run the following command (replace my_host with the host name of the computer running the network server and replace demo_path with the path relative to the database server):

    dbisql -c "UID=DBA;PWD=sql;Server=demo12;DBF=c:\demo_path\demo.db;host=my_host"

    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).


The application connects to the database.