ASA Database Administration Guide
  Connecting to a Database
    Simple connection examples

Using default connection parameters

You can leave many connection parameters unspecified, and instead use the default behavior to make a connection. Be cautious about relying on default behavior in production environments, especially if you distribute your application to customers who may install other Adaptive Server Anywhere applications on their machine.

Default database server and database 

If a single personal server is running, with a single loaded database, you can connect using entirely default parameters:

uid=user_id
pwd=password

Default database server 

If more than one database is loaded on a single personal server, you can leave the server as a default, but you need to specify the database you wish to connect to:

dbn=db_name
uid=user_id
pwd=password

Default database 

If more than one server is running, you need to specify which server you wish to connect to. If only one database is loaded on that server, you do not need to specify the database name. The following connection string connects to a named server, using the default database:

eng=server_name
uid=user_id
pwd=password

No defaults 

The following connection string connects to a named server, using a named database:

eng=server_name
dbn=db_name
uid=user_id
pwd=password

For more information about default behavior, see Troubleshooting connections.