Moving ODBC from one computer to another

Moving ODBC is not as challenging as you may think.  If you have a lot of ODBC setup in your system, the easiest way to move them is to simply save the registry entries and restore them on the new computer.

On 64 bit Windows:
64 bit ODBC’s are in – HKLM\SOFTWARE\ODBC
32 Bit ODBC’s are in HKLM\SOFTWARE\Wow6432Node\ODBC

On 32 bit Windows – HKLM\SOFTWARE\ODBC

===============================================================
Move ODBC from one machine to another (Same Architecture)

1) open the registry editor
2) select the ODBC folder under HKEY_LOCAL_MACHINE > SOFTWARE
3) export (xxx.reg file)
4) Import it into the registry on a different machine and reboot..

===============================================================
From 32 Bit Machine Registry to 32 Bit Registry on 64 Bit Machine

1) open the registry editor
2) select the ODBC folder under HKEY_LOCAL_MACHINE > SOFTWARE
3) export (xxx.reg file)
4) Edit the Reg file and replace all instances of
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
with
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI
4) Import it into the registry on a different machine and reboot..

Comments are closed.