ASA Database Administration Guide
Connecting to a Database
Simple connection examples
All Adaptive Server Anywhere database utilities that communicate with the server (rather than acting directly on database files) do so using Embedded SQL. They follow the procedure outlined in Troubleshooting connections when connecting to a database.
Many of the administration utilities obtain the connection parameter values by:
Using values specified on the command line (if there are any). For example, the following command starts a backup of the default database on the default server using the user ID DBA and the password SQL:
dbbackup -c "uid=DBA;pwd=SQL" c:\backup
For more information about options for each database tool, see the chapter Database Administration Utilities.
Using the SQLCONNECT environment variable settings if any values are missing. Adaptive Server Anywhere does not set this variable automatically.
For more information about the SQLCONNECT environment variable, see Environment variables.
Prompting you for a user ID and password to connect to the default database on the default server, if parameters are not set in the command line, or the SQLCONNECT environment variable.