Previous Topic

Next Topic

Book Contents

Book Index

Doing a Direct Connect

This section is for advanced users only.

AQT allows you to connect to a database without first having to define an ODBC Datasource. You would typically use this for a one-off database connection or when you need to specify some particular parameters on the connection.

If you are connecting to a file (such as an MS Access database, DBase file, SQLite database, Excel file or text files) the File Name box and selector will be enabled. You can specify the name of the file you are wishing to connect to. If you leave this blank, the ODBC Driver will prompt you for this.

Signon Direct2

Connection Strings

There is some information on the internet about the format of Connection Strings. One useful reference is at https://www.connectionstrings.com/

Alternatively, once you have signed onto a database, go Help > Database Details. At the bottom of this window there is a panel Connection Info. This shows you the connection parameters that the ODBC Driver has used to connect to the database (excluding the Driver name clause). For instance, if this is:

DSN=SAMPLE
UID=db2admin
PWD=******
DBALIAS=SAMPLE
ASYNCENABLE=1

Then a connection string that would connect like this would be:

Driver={IBM DB2 ODBC DRIVER};DSN=SAMPLE;UID=db2admin;PWD=******;DBALIAS=SAMPLE;ASYNCENABLE=1;

(replace ***** with your password).

Encrypted Passwords

To avoid specifying passwords in clear text, AQT allows you to use encrypted passwords. You would do this by replacing pwd or password in the connection string with epwd or epassword respectively.

Encrypted passwords are a feature of AQT only. Connection strings containing these cannot be used in any other product.

Example:

Driver={IBM DB2 ODBC DRIVER};DSN=SAMPLE;UID=db2admin;EPWD=&cBmgS6xDpeg4yGBvYog=tV;DBALIAS=SAMPLE;ASYNCENABLE=1;

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.