|
Home > Archive > MS SQL Server ODBC > May 2005 > Saving the username and password in the DSN
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Saving the username and password in the DSN
|
|
| Ryan Taylor 2005-05-04, 8:23 pm |
| I am wrting a vb application that connects to an MSDE database. I am using
ADO for the data objects and an OBDC DSN entry for connecting to the
database. Is there a way to store the username and password in the DSN entry
so that I do not need to supply this in code?
Alternatively, is there a simple, fast and efficient way to encrypt a
connection string if I cannot store this in the database. I do not want to
store the connection string in the code. It is too limiting.
Thanks.
| |
| Warren Read 2005-05-28, 8:23 pm |
| For security reasons, the user name and password are not stored in DSN's.
Anyone can access this information via the registry (for example,
HKEY_CURRENT_USER\So
ftware\ODBC\ODBC.INI\DSN_Test123)
Copying the user name and password to the DSN would allow anyone to see
this information.
I don't think drivers even try to read this information from the DSN's even
if you did store it there.
I'm pretty sure you need to enter this information every time you connect.
|
|
|
|
|