I need to make a system dsn connection on 50 pc.

It's a system dsn connection with sql users

I have though about to make a registry key, but I don't know where user and
password are in the registry.



My question is where in the registry can I find these keys?



CD

The SQL Server password is not stored with the ODBC DSN. With SQL
authentication, you'll need to specify the userid and password in your
application connection.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Carsten" <chd (AT) danfoss (DOT) com> wrote

Hi

If you can use a DSN-less connection, it will avoid all this and all the
subsequent support calls!!!

http://msdn.microsoft.com/library/de...datasource.asp

If you are going to add a DSN it is better to do it programmatically see
http://msdn.microsoft.com/library/de...datasource.asp
or through a proper installation.

You need to look in HKLM\Software\microsoft\ODBC\O*DBC.INI for the DSN
information.

John

"Carsten" <chd (AT) danfoss (DOT) com> wrote