Wednesday, September 15, 2010

ODBC Problems with 32-bit Office 2007 on 64-bit Windows 7

I recently solved an issue with ODBC compatibility on Windows 7 64-bit.  Our environment uses 32-bit Office 2007 and new computers are deployed as 64-bit windows 7.  Users complain that they aren’t getting the ODBC connection in Office even though they show up in the ODBC control panel.  Problem? The infamous Wow6432Node in the registry.

HKLM\Software\ODBC\ODBC.INI contains information for 64-bit connections.

HKLM\Software\Wow6432Node\ODBC\ODBC.INI contains the old 32 bit connections that office 2007 needs.

You can add the 32-bit versions by running c:\windows\SysWOW64\odbcad32.exe instead of the control panel version.  I chose to deploy these via Preferences in group policy.