ODBC Setup not saving password

[dvannoy]

I am setting up an ODBC connection through the ODBC manager in windows. When setting up the connection I checked "check for SQL authentication" with the user name of "sa" and my password..well going through the rest of the steps works fine..I even test the connection ..no problem. then i click OK to exit. then If I go back into the connection I setup the password is gone and the connection failed. is this a windows problem or a SQL problem?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

ODBC administrator does not save the password in the setup. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dvannoy]

OK..so when I setup the ODBC config on a users PC..should I use put there user id that was created in SQL as the users name in ODBC manager??

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

It really doesn't matter what you use in the ODBC setup. The login should be controlled by the application. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[vishnuprasad]

Its logical that ODBC will not save the password since its your app which should pass the password for security validation. The initial ask is just to test for connectivity.