Best Practices Question

Have a default LastUser and password in System DSN of ODBC connection.

01/15/2014 2908 views

Is there any way that we can save the password in System DNS of the ODBC connections.


stores the LastUser.

But is there a way that we can store the password also.


Thank you very much for all the help guys in advance.



1 Comment   [ + ] Show comment


  • Rats. I dont like it at all.

All Answers


It would be a very bad idea, as Microsoft found out with SQL Server 2000 over a decade ago.  It's not there for security reasons.

Answered 01/20/2014 by: vjaneczko
9th Degree Black Belt

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ