|
|
|
|
|
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.
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=SAMPLEUID=db2adminPWD=******DBALIAS=SAMPLEASYNCENABLE=1Then 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).
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;