System DSN Settings

[johnfli]

Here is a question for you.
I have 2 applications and both need a system DSN to connect to our SQL
Server.
For some reason, after I add teh second one, the first one will not work
anymore.
So I have to go back into teh setup for it and reset it's default database
to teh correct one as for some strange reason, it sets it to teh same one as
the new one.

Why is that and how do I keep that from happeneing?

Also, is there a way to setup the System DSN's remotely? With AD???

 

[Dave Patrick]

After you create them have a look in these keys. May reveal something.

HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

and also the subkey for each DSN
HKLM\SOFTWARE\ODBC\ODBC.INI\

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
Microsoft Certified Professional [Windows 2000]
http://www.microsoft.com/protect.


:
| Here is a question for you.
| I have 2 applications and both need a system DSN to connect to our SQL
| Server.
| For some reason, after I add teh second one, the first one will not work
| anymore.
| So I have to go back into teh setup for it and reset it's default database
| to teh correct one as for some strange reason, it sets it to teh same one
as
| the new one.
|
| Why is that and how do I keep that from happeneing?
|
| Also, is there a way to setup the System DSN's remotely? With AD???
|
|