Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database connections

 

Connecting to a running database on another computer (administration tools)

To connect to a database that is running on a network database server, you can use the Connect window with the Connect to a running database on another computer option.

Prerequisites

This procedure assumes that a database is running a network database server on a different computer. If it isn't already running, start a database server and database. For example, run the following command to start the sample database: 

dbsrv16 -n demo16 "%SQLANYSAMP16%\demo.db;"
 Task

  1. In Sybase Central or Interactive SQL, open the Connect window.

  2. Complete the following fields to connect to the database:

    1. In the Authentication dropdown list, click Database.

    2. In the User ID field, type a user name. For example, type DBA.

    3. In the Password field, type a password for the user. For example, type sql.

    4. In the Action dropdown list, click Connect to a running database on another computer to connect to a database that is running on another computer.

    5. In the Host field, type the host name of the computer where the database server is running.

    6. In the Server name field, type the name of the server or click Find. For example, type demo16.

      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.

    7. In the Database Name field, type the name of the database. For example, type demo.

  3. Optional: To obtain a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.

  4. Click Connect.

Results

The administration tool connects to the database.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0