Background: I have three developers I converted from Toad 9.1 to Toad 10.0. After I installed Toad 10.1.1.8 I copied the backed user files into the Toad 10 User file directory (C:\Documents and Settings\Jackson_I\Application Data\Quest Software\Toad for Oracle\10.0\User Files).
Problem: When I started up Project Manager, and double clicked a FTP, I got a password error. No big surprise because I thought the encryption had changed. So I re-typed the password and I connected Ok. However, after shutting down Toad and re-starting, the password did not work.
Next I tryed deleting the FTP and re-creating it. Same result the password was remembered until Toad was restarted … or the Project was closed and restarted.
So I deleted everything from the Project and recreated the FTP. Same result.
So I made a copy of my project.tpr and copied it to their User Files directory (overwriting their copy). Of course the password did not work, so I re-typed it … worked Ok … but the same result when I closed Toad and re-started - I got an invalid password error.
The last thing I tried was use the save button and overwrite the existing project.tpr. But the same result again.
Everyone I converted from 9.7 to 10 had not problem.
it sounds like the password contains something which doesn’t like being streamed
to disk when encrypted. this sounds familiar, I’m trying to recall something
like this having come up in the past.
by the way, you can look in the project.tpr file for a line starting with “4”
which is the identifier for an FTP node. It should look like:
I’m wondering if the password contains invalid characters for streaming to disk,
or for the encryption or something.
I just checked the source, and I’m still using an older encryption algorithm for
the PM, which is different than the main Toad FTP window which uses the same AES
algorithm as the oracle passwords use. So maybe you can check to see if the FTP
window works.
other than that I’m not sure. they work for my passwords here locally. I do need
to upgrade that PM FTP pwd algorithm, I’m surprised I haven’t yet
ProjectConfig.txt is the file that contains all the options and setttings for the project manager. The only relevant item there is the ‘save passwords’ option -
sorry, because of system problems I’m using the web to do email, I think I sent that accidentally.
anyway, ProjectConfig.txt is the file that controls options & settings within the PM, and the only relevant item there is the option to save the ftp passwords -
[Options]
SaveServerPwd,TRUE
other than that, no, the project.tpr file contains all the data.
I’m recalling something like this from a long time back, and I think it may have had to do with particular characters in the password. the passwords are the same as before? because I’m pretty certain the algorithm didn’t change from 9.1 (though it probably needs to now)
Then I export the dataset to clipboard with column headers and TAB delimiter.
Then I paste it into a running excel instance:
The columns Name and Value are now reverted to their original order. In TOAD 9.7
it respected the changed column order.
Is there an option to control this behavior or am I missing something?
I know that I could export it to directly Excel and it would work, but our
accountants want an ability to copy and paste the results of the queries into
their prepared excel templates.
Then I export the dataset to clipboard with column headers and TAB delimiter.
Then I paste it into a running excel instance:
The columns Name and Value are now reverted to their original order. In TOAD 9.7
it respected the changed column order.
Is there an option to control this behavior or am I missing something?
I know that I could export it to directly Excel and it would work, but our
accountants want an ability to copy and paste the results of the queries into
their prepared excel templates.
Then I export the dataset to clipboard with column headers and TAB delimiter.
Then I paste it into a running excel instance:
The columns Name and Value are now reverted to their original order. In TOAD 9.7
it respected the changed column order.
Is there an option to control this behavior or am I missing something?
I know that I could export it to directly Excel and it would work, but our
accountants want an ability to copy and paste the results of the queries into
their prepared excel templates.