In Windows 7, Toad for Oracle saves the connections and password in the files located in %USERPROFILE%\AppData\Roaming\Quest Software\Toad for Oracle\[version#]\User Files\


  • CONNECTIONS.INI
  • CONNECTIONACTIONS.INI
  • CONNECTIONPWDS.INI


Passwords are stored in encrypted way in CONNECTIONPWDS.INI file. If you forget the saved passwords for some Oracle users, you can retrieve them back from the encrypted password file CONNECTIONPWDS.INI using the following tricky way.

The Trick:
  1. Login in Toad as any user (has saved or not saved password).
  2. Choose Database | Create | DB Link menu item from toolbar
  3. Fill fields of the DB Link name, DB connection, and User to connect.
  4. Then the password will be filled automatically if they are saved in the encrypted passwordfile before.
  5. Click “Show SQL” button, the saved PW will be shown in the generated sql.