Sunday, February 19, 2012

How to copy DSN from one server to another?

I need to setup identical System DSN ODBC connections on multiple servers...
is there a way to easily migrate the System DSNs from one server to another?
Generally, file DSNs are used if needing to move DSNs around
to other machines (or ideally use DSN-Less connections). But
I know some people have copied system DSNs by exporting the
following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
-Sue
On Tue, 11 Jan 2005 12:03:04 -0800, Ron Niederer <Ron
Niederer@.discussions.microsoft.com> wrote:

>I need to setup identical System DSN ODBC connections on multiple servers...
>is there a way to easily migrate the System DSNs from one server to another?
|||Ron,
Please try out our free ODBC manager (www.sqledit.com/odbc) for this
purpose.
RN> I need to setup identical System DSN ODBC connections on multiple
RN> servers... is there a way to easily migrate the System DSNs from one
server to
RN> another?
Igor Shekalev, http://www.sqledit.com, powerful database tools

No comments:

Post a Comment