Connecting to a running database in a cloud (dbsrv12)

To connect to a database that is currently running in the cloud, you can use the Connect window with the Connect to a running database in a cloud option.

Prerequisites

To connect to a database in the cloud, you must supply at minimum a host in the cloud, the name of the database, and a user ID and password for the database.

Context and remarks

To ensure that you can connect to the cloud, it is recommended that you specify the hosts and ports for the cloud partners and the cloud arbiter.

 Connect to a running database in a cloud (Sybase Central or Interactive SQL)

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

  2. Complete the following fields:

    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 in a cloud to connect to a database that is running on another computer.

    5. In the Host field, type the host name of the cloud arbiter and one of the cloud partners.

    6. In the Port field, type the TCP/IP port on which the cloud arbiter is running, followed by the port on which the cloud partner is running.

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

  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.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1