Contents Index Using default connection parameters Working with ODBC data sources

ASA Database Administration Guide
  Connecting to a Database
    Simple connection examples

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:

  1. 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.

  2. 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.

  3. 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.


Contents Index Using default connection parameters Working with ODBC data sources