You can Script a database sign-on. 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 sign-on 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 Sign-ons list.
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.
To sign on to a database using a File DSN use the following procedure:
An alternate procedure is:
filedsn=<filename>where filename is the name of the filedsn file.
Information on your Datasources is 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.