469,610 Members | 1,710 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

System DSN / Registry

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
Jul 23 '05 #1
2 6564
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" <ch*@danfoss.com> wrote in message
news:42*********************@dtext01.news.tele.dk. ..
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

Jul 23 '05 #2
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" <ch*@danfoss.com> wrote in message
news:42*********************@dtext01.news.tele.dk. ..
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

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

25 posts views Thread by Mike MacSween | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.