To connect to a database that is currently running on a networkd 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 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 SQL Anywhere 12 sample database:
dbsrv12 -n demo12 "%SQLANYSAMP12%\demo.db"
Context and remarks
In Sybase Central or Interactive SQL, open the Connect window. See Opening the Connect window (Sybase Central).
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 demo12.
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).
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 © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|