Toad World® Forums

Project Manager - FTP - convert Toad 9.1 to Toad 10.0


#1

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.

Any ideas?

Thanks
Ian Jackson


#2

Hi Ian,

Under Project Manager options, General tab, do you have “Save FTP Passwords” turned on?

Mark



#3

yes … that is checked.

ian


#4

yes, I checked that and it is turned on.
thanks
ian


#5

I was thinking about this … maybe it was one of the 9.1 .ini files that overwrote the 10.0 ini files in /user_files directory.

Is there a particular .ini file that controls project manager and/or ftp?

Thanks
ian


#6

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:

4,"[ORA10GR2] /",ORA10GR2,username,lT7—”&&&&****,/,21,FALSE,FTP,

where the gibberish is the password.

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


#7

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 -



#8

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)



#9

Lets say I run a query:

select * from v$sga;

It returns the following data:

Then I change the column order in the grid:

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.

Many thanks for your help.

George
image001.jpeg


#10

Lets say I run a query:

select * from v$sga;

It returns the following data:

Then I change the column order in the grid:

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.

Many thanks for your help.

George
image003.jpeg


#11

Lets say I run a query:

select * from v$sga;

It returns the following data:

Then I change the column order in the grid:

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.

Many thanks for your help.

George
image002.jpeg


#12

It’s a bug. I just fixed it a few days ago in beta.
image001.jpeg


#13

It’s a bug. I just fixed it a few days ago in beta.
image003.jpeg


#14

It’s a bug. I just fixed it a few days ago in beta.
image002.jpeg


#15

So, we have to wait for a new version or a patch is planned?
image002.jpeg


#16

So, we have to wait for a new version or a patch is planned?
image003.jpeg


#17

So, we have to wait for a new version or a patch is planned?
image001.jpeg


#18

So, we have to wait for a new version or a patch is planned?
image001.jpeg


#19

No more patches are planned.
image001.jpeg


#20

No more patches are planned.
image002.jpeg