Syncing ODBC System DSN's between servers

[Guest 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

[Guest Dave Patrick]

Re: Syncing ODBC System DSN's between servers

 

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

 

"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