Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » SQL Anywhere database connections » Sample SQL Anywhere database connections

 

Connecting from SQL Anywhere utilities

All SQL Anywhere database utilities use embedded SQL to communicate with the server.

How database utilities obtain connection parameter values

Many of the administration utilities obtain the connection parameter values by:

  1. Using values specified on the command line. 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 the options for each database utility, see Database administration utilities.

  2. Using the SQLCONNECT environment variable settings if any values are missing. SQL Anywhere does not set this variable automatically.

    See SQLCONNECT environment variable.