Other notes on database signon

Scripting

You can Script a Database signon. This is mainly designed for use with Batch Mode operation of AQT. However, in normal AQT operation you can run a script with a number of Connect functions. This can be used to sign on automatically to a number of databases without having to go through the Signon dialog. Scripting > Connect function gives more information on this.

You can also auto-connect to a database by checking the Auto-connect when AQT starts button on the Recent Signons list.

Reconnecting

Within the Database Explorer there is an option File > Reconnect to Database. This will disconnect you from your current session with the database, and reconnect you to it. This option is useful if your database session has timed-out or been disconnected for some other reason. The Reconnect option allows you to quickly re-establish the database connection.

Using a File Data Source

To sign on to a database using a File DSN use the following procedure:

• select Advanced > Prompted Signon
• click on Sign On
• you will be shown the "full" ODBC Signon dialog. Go to the File Data Source tab, select the appropriate File DSN and click on OK.

Registry entries for Datasources

Information on your Datasources are held in the Registry under key Software\ODBC\ODBC.INI. For System Datasources these are in HKEY_LOCAL_MACHINE, for User Datasources these are in HKEY_CURRENT_USER.

While it is not recommended practice, it is possible to manipulate these entries using regedit. An example would be copying a set of entries from one machine to another. Note that this will only work if the relevant ODBC Drivers have been installed on the target machine, and the database client has been installed and configured.