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:
ENG=server-name UID=user-id PWD=password |
The following connection string connects to a named local server, using a named database:
ENG=server-name DBN=db-name UID=user-id PWD=password |
To connect to a network server running on a different computer:
ENG=server-name
DBN=dbn
UID=user-id
PWD=password
CommLinks=tcpip |
If CommLinks 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 select the Search Network For Database Servers option on the Connect window to attempt a network connection.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |