System DSNs, SQL and regedit

[Samuel Checker]

We're trying to automate inserting system DSNs using a .reg file. The
file works up to a point, but so far I have not found a way to insert
the proper password. The authentication method is SQL server, not NT.

The relevant section of the file looks like
[HKEY_LOCAL_MACH INE\SOFTWARE\OD BC\ODBC.INI\vbW hadeva]
"Driver"="C:\\W INNT\\System32\ \SQLSRV32.dll"
"Server"="DBSER VER"
"LastUser"="vbW hadeva"
"PWD"="knuckleh ead"


The PWD, I admit, was a blind stab in the dark.

Anyone worked this out? Googling and KB searches aren't doing it for
me, but I might be looking in all the wrong places.

[Dan Guzman]

Re: System DSNs, SQL and regedit

You need to specify the SQL Server login and password in your connection
string since these are not stored in the DSN. It would be a security
hole if these were stored with the DSN.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800

http://www.sqlserverfaq.com

http://www.mssqlserver.com/faq

-----------------------

"Samuel Checker" <sc@pffcu.com > wrote in message
news:2075ad45.0 309020612.f974b 38@posting.goog le.com...[color=blue]
> We're trying to automate inserting system DSNs using a .reg file. The
> file works up to a point, but so far I have not found a way to insert
> the proper password. The authentication method is SQL server, not NT.
>
> The relevant section of the file looks like
> [HKEY_LOCAL_MACH INE\SOFTWARE\OD BC\ODBC.INI\vbW hadeva]
> "Driver"="C:\\W INNT\\System32\ \SQLSRV32.dll"
> "Server"="DBSER VER"
> "LastUser"="vbW hadeva"
> "PWD"="knuckleh ead"
>
>
> The PWD, I admit, was a blind stab in the dark.
>
> Anyone worked this out? Googling and KB searches aren't doing it for
> me, but I might be looking in all the wrong places.[/color]