Syncing ODBC System DSN's between servers

28 Nov 2007 5:59 PM

Dave Navarro

How can I synch the ODBC System DSN's between multiple servers?

Our primary software requires a System DSN for each new database we
create. So at the moment, every time we add a new database I have to
manually log on to each of 5 servers and add the new System DSN.

Is there some way to do it on one master server and then synch it to the
rest?

Thanks!

--Dave

29 Nov 2007 3:27 AM

Dave Patrick

You can create a *.reg file from;

You'll need to get the subkey with the DSN names
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

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

or you can use RegWrite method to create the keys/ values.

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 Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Show quoteHide quote

"Dave Navarro" wrote:
> How can I synch the ODBC System DSN's between multiple servers?
>
> Our primary software requires a System DSN for each new database we
> create. So at the moment, every time we add a new database I have to
> manually log on to each of 5 servers and add the new System DSN.
>
> Is there some way to do it on one master server and then synch it to the
> rest?
>
> Thanks!
>
> --Dave