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.
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;"
In Sybase Central or Interactive SQL, open the Connect window.
Complete the following fields to connect to the database:
In the Authentication dropdown list, click Database.
In the User ID field, type a user name. For example, type DBA.
In the Password field, type a password for the user. For example, type sql.
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.
In the Host field, type the host name of the computer where the database server is running.
In the Server name field, type the name of the server or click Find. For example, type demo16.
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.
In the Database Name field, type the name of the database. For example, type demo.
Optional: To obtain a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|