Discussion Locked

Cached Passwords IN Win2K

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have just rolled out Windows 2000 into our environment and there is a problem: In the previous systems, some team members used NT 4.0 with Access 97. They would build reports that used Oracle tables - and when they constructed the db's, the program would ask them to provide the username/password for the oracle tables and a check box to save it...if you check the box - the password is saved and everytime you run the report, you are not asked to provide the username/password for the Oracle tables. There was no security built into the Access files themselves...

So now in Windows 2000 (and Office 2000) - even though we check the box to save the passwords...it does not. Consequently, everytime the report runs (hitting any of the Oracle tables located on a different server), it prompts for a password for every Oracle table it needs...and there are several...
I am thinking this is a Windows 2000 security issue perhaps??? Is there a checkbox that we need to find...a registry issue thatwe can change....Give me a clue...

5 replies

by michel

Check the version (and supplier) of the ODBC drivers for Oracle. This password thing is a function of the ODBC driver.

by andrew_hodgson

My problem is with RAS/Dial-up Networking but the symptoms are the same. When I log on to my ISP, having previously checked Save Password, the password is rejected. The reason is that Save password is saving the asterisks it uses to hide the password rather than the password itself (I devised a test to find out what was happening). As yet, I have been unable to get support from IBM (the OEM for Win 2K Pro) so I have no solution.

This discussion is closed to new replies.