Re: Export ODBC?

From: Andrey (leyandrew_at_yahoo.com)
Date: 09/19/04

  • Next message: Patrick Tang: "Problem with ASP and SQL ODBC connection" 
    Date: Sun, 19 Sep 2004 06:48:21 GMT

    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

  • Next message: Patrick Tang: "Problem with ASP and SQL ODBC connection"

    Relevant Pages

    • Re: Change servername based on logon server
      ... maybe a File DSN would be a more secure bet? ... short application to the logon script that only touches the registry keys ... Yes the server name is stored in the HKCU. ... We propose to use a reg file attached to a logon script to amend the ...
      (microsoft.public.sqlserver.odbc)
    • Re: Append to an Existing REG_SZ Value in Registry Using a .Reg Fi
      ... "Pegasus (MVP)" wrote: ... Value1's data is equal to "String1", then how can I modify Value1's ... If you run the process I described on the target machine ... the .reg file that was created and then apply the .reg file. ...
      (microsoft.public.windowsxp.general)
    • Re: ODBC Sessions
      ... If you use system DSN's then you can create a *.reg file from; ... You'll need to get the subkey with the DSN names ... Microsoft MVP [Windows] ... | Is it possible to transfer ODBC sessions configured on a Windows 2000 ...
      (microsoft.public.win2000.general)
    • Re: creating a dsn in script
      ... For User DSNs, look in: ... Just right click on the key under the ODBC.INI key that pertains to your DSN ... Where C:\dsn.reg is the path and filename for your reg file. ... "Dan D." ...
      (microsoft.public.scripting.wsh)