You can use default behavior to make a connection and leave the connection parameters unspecified. However, using the default behavior in a production environment can cause problems if the application is installed with other SQL Anywhere applications. For more information about default behavior, see Troubleshooting connections.
Use the default parameters to connect to a single personal server with a single database:
UID=user-id PWD=password |
If more than one database is on a single personal server, use the default server settings, and specify the database you want to connect to:
DBN=db-name UID=user-id PWD=password |
If more than one server is running, specify which server you want to connect to. You do not need to specify the database name if only a single database is on that server. The following connection string connects to a named server, using the default database:
Server=server-name UID=user-id PWD=password |
The following connection string connects to a database running on a different computer:
Host=host-name DBN=db-name UID=user-id PWD=password |
The following connection string connects to a named local server, using a named database:
Server=server-name DBN=db-name UID=user-id PWD=password |
To connect to a network server running on a different computer:
Host=host-name Server=server-name DBN=dbn UID=user-id PWD=password |
If Host is not specified, only local shared memory connections are attempted.
If you are connecting from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility (dbconsole), you can choose the Connect To A Running Database On Another Computer option on the Connect window to attempt a network connection.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |