You can leave many connection parameters unspecified, and instead use the default behavior to make a connection.
Be extremely cautious about relying on default behavior
in production environments, especially if you distribute your application
to customers who may install other Sybase IQ or Adaptive Server
Anywhere applications on their machine.
If you are connecting to a database on your local server, and more than one database has been started on that server, you need to specify the database you wish to connect to, but you can leave the server as a default:
dbn=db_name uid=user_id pwd=password
Do not use these parameters if more than one local server
is running, or you may connect to the wrong server.
If more than one server is running, you need to specify which one you wish to connect to. If only one database has been started 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
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 “How Sybase IQ makes connections”.
