Using default connection parameters

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.

Default database server and database

Use the default parameters to connect to a single personal server with a single database:

UID=user-id
PWD=password
Default database server

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
Default database

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
No defaults for a local server

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
No defaults for a network server

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.