Advanced Sign-on options

Click on Advanced to see some more advanced options for your sign-on:

No Password

If your user-id has no password you can’t just leave the password field blank; if you did AQT will assume you are doing an integrated log-on and pass neither the user-id nor password in the sign-on request. Check No Password - AQT will then sign-on specifying the user-id but not the password.

Prompted Sign-on

If you are having problems signing on, or if you need to enter some database-specific parameters, you should do a Prompted Sign-on. Prompted Sign-on invokes the log-on system supplied by the database vendor, giving you better control of the sign-on process.

Prompt for Missing Info

If you need to specify additional information for a connection, check Prompt for Missing Info. You would use this if you have configured an ODBC Datasource that hasn't specified the complete information needed to connect (some people use this as a way of configuring a Generic connection).

Show Password

If you are getting an error specifying your password, and you want to see what password you have really typed, check Show Password. This will show your password in clear text.

Note: this option will only be enabled once the password field is cleared (this prevents you from seeing an already-entered or saved password).

Set pwd when select dbs

This option is only relevant when you are in Show All mode

• When you are in Show Recent mode and click on a database, AQT will retrieve the saved userid and password for the database.
• When you are in Show All mode, whether AQT retrieves the saved userid and password will depend on the Set pwd when select dbs setting.
  • if this option is not set (the default) AQT will not set the userid and password. They will retain the values they were prior to selecting the database. This can be useful if you have a lot of databases with the same userid and password.
  • if this option is set, AQT will retrieve the saved userid and password for the database (if one has been saved). AQT will do this by going through the list of recent signs looking for a saved-signon entry for that database. If it finds one, the userid, password (and other connection info) are retrieved accordingly.

    If there are multiple saved-signon entries for that database (with different userids and passwords), AQT will use the first one it finds. If AQT finds no saved-signon entry for the database, the userid and password fields will be set to blank.

Database Name

For SQL Server, Sybase Enterprise, MySQL and Informix you can specify which database you want to sign on to. By default, you sign on to the database specified in your profile.

Oracle Privileges

When signing onto Oracle, you can specify that you are signing on with sysdba or sysoper privileges.

This feature is only available if you are using v9.2 or higher of the Oracle ODBC Driver. If your ODBC Driver does not support this syntax, you will get the message: invalid username/password

Number of entries in recent list

This specifies the number of entries AQT is to save in the Recent Database list. You can specify a value between 1 and 100.

A high value has a (slight) impact on performance as AQT saves the Recent Database list every time you sign onto a database.