iAnywhere.com - Connecting from Adaptive Server Anywhere utilities

Connecting from Adaptive Server Anywhere utilities

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.

How database tools obtain connection parameter values

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.