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.

Prerequisites

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

Caution

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 (Sybase Central or Interactive SQL)
  1. In Sybase Central or Interactive SQL, open the Connect window. See Opening the Connect window (Sybase Central).

  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:\path_demo\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 demo.

    7. In the Server Name field, specify a name for the server. For example, type demo12.

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

    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.

Results

The administration tool connects to the database.

Next

None.

 See also