Migrate ODBC config settings and drivers from XP 32-bit to Windows 7 64-bit?

Question

How can the ODBC settings and ODBC-related drivers from one user's 32-bit XP be exported out and imported into a different user's Windows 7 64-bit computer?

Answer 1

Hello,

Please, could you tell the kind of ODBC driver you want to use ( SQL Server,Access,Excel,...) ?

Also could you tell the version ( usually the year ) for SQL Server,Access,Excel,... ?

We are waiting for your feedback to try to help you more efficiently.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

It's a very old custom app that uses Oracle 8 and 9.

Answer 3

Hi Mygposts,

>> It's a very old custom app that uses Oracle 8 and 9.

Thank you for your update. Seems you are using Oracle, 32 bit software requires 32 bit odbc driver and 32 bit client and 64 bit software requires 64 bit odbc driver and 64 bit client.

On Windows 7 64-bit, there are two ODBC Administrator control panels. There's a 32-bit one, and a 64-bit one. 32-bit apps cannot use the 64-bit ODBC drivers. 64-bit apps cannot use 32-bit ODBC drivers. So in Windows 7 64-bit, Microsoft created two ODBC Administrator consoles for setting up the appropriate drivers.

32-bit ODBC connections are setup in %WINDIR%\SysWOW64\odbcad32.exe - this you can launch from the Command Prompt
64-bit ODBC connections are setup in %WINDIR%\System32\odbcad32.exe - this is what launches when you go to Control Panel > Administrative Tools > Data Sources (ODBC)

For more information, please refer to indows x64: 32bit Odbc vs 64bit Odbc http://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/
For some issue related to Oracle please link to Oracle forums for further help.

---

Regards, Amber zhang