May 14, 2004 at 8:38 am
Hello,
For one of our SQL Server databases we use Access as the front end which links to the database through an ODBC source. Everytime the user goes in and out of access they have to re-enter their password. Is there anyway to hard code the password for the odbc driver in a registry string value?
Thanks in advance,
Belinda
May 14, 2004 at 12:19 pm
Belinda,
Are you looking for a way to dynamically create the links, or a way to store something in the registry, or both?
Richard
May 17, 2004 at 11:17 am
I am looking for a way to store a password in the registry.
Belinda
May 17, 2004 at 12:15 pm
You can use GetSetting and SaveSetting, but you will need some sort of crypto function to secure it though.
Hope this helps,
Richard
July 8, 2004 at 10:48 am
Why not use NY authentication rather than a SQL user ID? That way they don't get prompted for a login b/c SQL detects their NT user ID.
You just have to setup the NT user ID in SQL with permissions first and then change your DSN to use NT authenctiation aka Trusted Connection.
July 10, 2004 at 3:26 pm
Or when you link in the table(s) make sure you click the "Save Password" box
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply