Connecting to a Running Database on Another Computer

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.

1. Open Interactive SQL, located at STREAMING_HOME/sqla/Bin64/dbisql
2. If the Connect window does not open automatically, click  SQL  Connect  or press F11.
3. 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 running database server. For example, type demo16.
      Note Since a computer system can run multiple SQL Anywhere database servers, always specify the database server name when connecting to a database.
   1. In the Database name field, type the name of the database. For example, type demo.
4. (Optional) To get a copy of the connection string that is created with this window, click  Tools  Copy Connection String to Clipboard .
5. Click Connect.