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

 

Starting and connecting to a database on another computer (administration tools)

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

Prérequis

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

dbsrv16 -n myserver -gd all

The -gd all option is not recommended because it permits any user to start a database on a server. This option is required for the following scenario. If your database page size is larger than the default of 4096, then specify the -gp option.

 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 Start and connect to a database on another computer.

    5. In the Database File field, type the path and extension of the database file, relative to the database server.

      For example, type C:\Users\Public\Documents\SQL Anywhere 16\Samples\demo.db.

    6. To create a database name that is different from the file name for subsequent connections, type a name in the Database name field. Do not specify a file path or extension.

      For example, type mydemo.

    7. In the Server name field, specify a name for the server.

      For this example, use the server name myserver that was specified above.

      Since the host computer may be running several database servers, it is recommended that you always specify the database server name.

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

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

  4. Click Connect.

Résultat

The administration tool connects to the database.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0