ODBC DSN not appearing 64 bit OS

This one had me stumpped for a bit, thanks to my colleague for getting to the bottom of this one.

Running a 64 bit OS, set up an ODBC DSN, but can’t select it in my 32 bit application, which is of course the AX server configuration utility for AX4. This is weird because the ODBC connection tool is still a 32 bit app even on a 64 bit OS. The trick is that there is actually another secret version of the ODBC tool!

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):

  • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

  • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

The 64-bit version of obdcad32.exe is the one you get from administrative tools, if you want to set up DSNs for 32bit apps then you need to manually go and run the ODBCad32.exe in the windows\SysWoW64\ folder.

This is taken from a Microsoft Knowledge base article KB942976!

Comments (2)

  1. gl00mie says:

    I think "the trick" is not in the secret version of the ODBC tool, but in separate regitry keys for 32-bit apps in 64-bit Windows (HKLMSOFTWAREWow6432Node, HKCUSOFTWAREWow6432Node, etc). When 32-bit apps access SOFTWARE registry key (and some others) in a 64-bit Windows they are actually redirected to a corresponding Wow6432Node subkey not to mess settings for 64-bit apps, and vice versa when you change registry setting for 64-bit apps then 32-bit apps would most likely not see these changes.

    See "registry redirection" in kb896459 http://support.microsoft.com/kb/896459/