The passwords for the connections are not saved

Toad for Oracle
1

Hello,

I have installed the last version of Toad Xpert 12.5.1.1. with DB Admin. I have a big problem because my passwords for the connections are not saved. And more the probleme is intermittent!

Can someone help me please!

My poste is in Windows 7 et I’m not the system’s administrator.

Thank’s very much.

Christiane Pépin
Administratrice de bases de données
Direction du développement
Direction principale des systèmes d’information
Ministère des Finances

8, rue Cook, 3ième étage, 3.09-C Québec (Québec) G1R 0A4

Téléphone : 418 646-4244
Télécopieur : 418-644-3964
christiane.pepin@finances.gouv.qc.ca

www.finances.gouv.qc.ca

2

Is “Save Passwords” checked? It’s at the bottom of the login screen.

3

i tried upgrade to 13.3 (from 13.1.*) for oracle this morning and the upgrade did not complete successfully. However, it wiped out all my saved connection passwords. I have over 10 connections saved. I tried re-import what I exported a few weeks ago but it doesn't do anything. How can I remove all the saved connection and re-import.

4

Export/Import toolbar buttons are shown below:
image

In 13.1, Export to file.
In 13.3, Import the file.

To delete connections, CTRL+A in the grid, then hit Delete key.

5

Thank you. That fixed my problem.

6

After working fine for a couple of days. The saved connection passwords are messed up again. I went to connect and got the invalid password error. I had to update the password again. Why is it not saving the passwords any more? Until my attempt to upgrade, I never had this issue. Any ideas?

7

Is the "save passwords" checkbox on the login window checked? It needs to be.

Have you logged into windows using a different user name? The encryption/decryption of passwords is tied to that, so Toad won't be able to decrypt passwords if they were encrypted under a different windows user.

I don't know of any problems in Toad with saving of passwords.

8

Yes, the save password was checked. I rechecked it two days ago when I had to reimport the connection strings. This happens during the first morning login when Toad tries to "recover" some lost sessions which BTW never worked. Now I asked Toad to removed the old sessions perhaps it will start to work.
I only have one windows account/credential.

9

By "Sessions" do you mean text in the Editor?

10

This finally starts to work after I got rid of all the old editor sessions toad was trying to recover.

11

If you can provide some steps to reproduce the problem, we will try to fix it.

Is it something like this? Please correct me if this is wrong.

  1. type stuff in editor but don't save, wait a few minutes. (to create editor contents recovery file)
  2. kill Toad (so Toad will prompt to recover editor contents on next start)
  3. change password from SQL Plus
  4. start Toad with auto login (supply new password when asked)
  5. double-click to restore the saved editor contents
  6. Close and restart Toad to see if changed password is saved
12

sort of but not exactly. If it happens again, I will try to remember the steps. After my attempt to upgrade to toad 13.3 failed, I had a lot of trouble saving the passwords. It is now finally working , keep my fingers crossed.

13

Hello Quest people,
I have got the same problem with Exp/Imp connections with passwords to the backup PC.
I use: TOAD 15.0.97.1178 on both PCs

PC1: full ORacle_clint
PC2: Oracle instant client (different path)

  1. EXP connections with passws (set master pass)
  2. View exp_file - I an see O_H and passws
  3. move file to PC2
  4. IMP connections (used Master pass)
  5. no passwords are in the Connection list
  6. no Home is filled
  7. Connection with filling the Pass is workig well

I tried direct copy of "Connections.xml" file and not helped to me too.

Could you help me?

Thank you,
Mls

14

Copying Connections.XML won't work because the password is encrypted there and can only be decrypted on the machine that encrypted it.

You must export connections to a new file like this. Fill all the highlighted fields.

image
image720×563 36.6 KB

Then copy the new file to another PC and import it like this:

image
image708×566 29 KB

I just tested this (exporting from beta, importing to 15.0) and it worked for me.

It's OK that the home is different. The home is different for me too.

15

Nice,
I can see you have made the same process as me. And you are successfull, great!
I know this procedure I have used it during a replacement of my PC several times in the past.

I am thinking about my unsuccessfull progress. I did it 4 times with the same result, so I tried a copy method as the last try.
What is different?
PC1 is a usual desktop computer.
But...
PC2 is my new personal Citrix VDI workspace (not hardware PC) at another geolocality. It should be used in disaster case only.

Can it be the reason for skipping passwords during import?

Thank you or your advice,
Mls

16

I don't think it makes any difference the type or location of PC.

I just thought of something else.

Before you import....on the 2nd pc, make sure that the "save passwords" box is checked at the bottom of the login window

17

BINGO !!!!!
You are a king! :sunglasses:

Of course I hadn't got checked box on PC2.
Now I have imported all including passwords.
Thanx a lot,
Mls

1 Like
18

Great! I'm glad that was it. I'll fix it.

19

I have same issue with v17.0. It was working fine for over a year until a hard boot of PC. I tried upgrading to ful 17.1 but that new install doesn't even show the "Save" checkbox in the Connections window!

It saves the connections Passwords. And they are still there after a Toad close and reopen. But then seemingly randomly disappear a few restarts later. The passwords are in the connection.xml file so it seems to be ignoring it!

p.s. (And this does not relate to the above noted problem) Is Toad ever going to be "fixed" to save custom changes to settings as soon as you click Ok to close the Settings popup window?! It saves them only upon normal Toad app close/exit. So if Toad crashes all the custom settings are lost. i have observed this behaviour since i first touched Toad 20 years ago.

20

Hi Tstaresi,

The "Save Passwords" option was removed from the login window's status bar because that is a non-standard place to put options.

You can find the option here or in the main Toad options window

image
image614×515 23.1 KB

p.s. (And this does not relate to the above noted problem) Is Toad ever going to be "fixed" to save custom changes to settings as soon as you click Ok to close the Settings popup window?! It saves them only upon normal Toad app close/exit. So if Toad crashes all the custom settings are lost. i have observed this behaviour since i first touched Toad 20 years ago.

Yes, Toad saves settings as soon as you click OK or APPLY in options window. It's been this way for several versions. It also automatically saves settings once per minute (as long as there has been activity in Toad since the last save). If you are losing settings, my guess is that you have multiple copies of the same version of Toad open and they are overwriting each other's settings.

Edit: I was able to get both (Deleted) and (Modified) to appear by following these steps:

  1. create a workspace
  2. put some text in the editor and save to a file
  3. save the workspace and close Toad
  4. delete the file (actually I copied it somewhere else)
  5. start Toad and open the workspace the (Deleted) tag appears, as expected
  6. restore the file at the OS level
  7. Go back to Toad - the tag changes to (Deleted) (Modified)