I have 2 load balanced servers. One went down and I am
rebuilding it, I would like to somehow import all of my
DSN's from box #2 so I don't have to recreate it all. I
would also if possible like to set up appcenter to
replicate the DSN's over so that I only have to create
them on one box. Is there a flat file or something
somewhere that has all of this info so I can just
replicate it over? Any help would be greatly appreciated!

Ishmeal wrote:

> I have 2 load balanced servers. One went down and I am
> rebuilding it, I would like to somehow import all of my
> DSN's from box #2 so I don't have to recreate it all. I
> would also if possible like to set up appcenter to
> replicate the DSN's over so that I only have to create
> them on one box. Is there a flat file or something
> somewhere that has all of this info so I can just
> replicate it over? Any help would be greatly appreciated!

Well, first when you add a new ODBC connection you should considering adding a "File DSN" instead of
"System/User DSN" and store it on a network share, this way if you ver need to use ODBC connection
on a new computer, you don't care about transferring DSN's in any ways, you use the existing File
DSN pointing to the DSN file stored on the mentioned share.

Second, what should you do to transfer existinf System DSN to another machine?
System DSN's are stored in windows registry under HKLM\Software\ODBC\ODBC.INI node
So if you export this node to a *.reg file and run this reg file on a target machine, it should do
the trick.

The only thing, this reg file will contain some file paths which maybe computer specific, eg
c:\WINNT\System32\bla-bla-bla.dll includes WINNT folder which on target machine may be called like
WINDOWS. So you will need to spend a bit time to make sure all paths in *.reg file are correct for
target machine.

Please let me know if it works for you!

Andrey