how do i clear/change odbc uid logon field ?

[Advocate]

alright i give up !

i created a pass-through-query to an oracle database and opted not to save password

now, everytime i run the query, it pops up with testing uid disabled (ie i can not change it) and prompting for a password

i need to allow several users to run the query with their own uid and password

could not find anything on forum - any ideas please ?

i know it is probably something very subtle and simple, so i am prepared to be embarassed ...


regards, david - no such thing as problems - only solutions.

 

[Advocate]

oops ! found the answer ... uid was stored in win nt4 control panel oracle odbc setup configuration (IT WASNT ME !!!)

tanx anyway ...

regards, david - no such thing as problems - only solutions.