473,327 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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 6693
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Nick Kew | last post by:
Rationale ========= Many applications today benefit from an SGML and/or XML Entity Catalogue to dereference entities referenced by a Public Identifier. For a validating SGML parser this is an...
25
by: Mike MacSween | last post by:
Yes, I've downloaded and read the FAQ. And searched the archives. I'm just treading a little carefully here because of the caveats about locking myself out of the db forever. Some answers I could...
9
by: Ben Dewey | last post by:
Project: ---------------------------- I am creating a HTTPS File Transfer App using ASP.NET and C#. I am utilizing ActiveDirectory and windows security to manage the permissions. Why reinvent...
6
by: John Hoffman | last post by:
Reading registry: .... RegistryKey rksub = rkey.OpenSubKey(s); String valstr = rksub.GetValueNames(); foreach (String vs in valstr) { String vstr = rksub.GetValue(vs).ToString(); OR String...
2
by: Ray5531 | last post by:
I keep getting this error when my asp.net application tries to write into the registry System.Security.SecurityException: Requested registry access is not allowed. I followed the following...
5
by: Ankit Aneja | last post by:
This is my problem. I am using Visual 2003, .Net framework 1.1 and the Application Block I configured the DAAB using the Enterprise Library Configuration now this is the error which is coming ...
8
by: Bryan Dickerson | last post by:
The full message is: Request for permission of the type 'System.Security.Permissions.RegistryPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. ...
4
by: kalichakradhar | last post by:
hi, I am new to VB.. I am dedveloping a tool in which there would be a browser/text box to open the desired file.. the problem here is that i want to remember the old file that i opened last time...
3
by: Evan | last post by:
Hello, one of my PC is window system, and in "control panel -Network Connections", I can see some network connections such as PPPOE or VPN which I created by click "create a new connection". ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.