Collection Contents Index Using default connection parameters Next PDF

SQL Anywhere® Server - Database Administration  > Connecting to a Database  > Simple connection examples

Connecting from SQL Anywhere utilities


All SQL Anywhere database utilities that communicate with the server (rather than acting directly on database files) do so using embedded SQL.

For information about the procedure the utilities use when connecting to a database, see Troubleshooting connections.

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


Collection Contents Index Using default connection parameters Next PDF