Thursday, October 8, 2009

How to Create an ODBC Connection for 32-bit application on 64-bit Windows

Just a reminder post really. Had a colleague today that was installing a 32-bit application on Windows 2008 x64 that required an ODBC connection. The trouble with this is that the default ODBC (Data Sources) under Administrative Tools opens the 64-bit driver version of the ODBC tool.
Therefore even though he had created the connections correctly the 32-bit application could not see them. To make things a little confusing 64-bit Windows versions install the 64-bit ODBC tool under C:\Windows\System32.
The 64-bit version is installed under C:\Windows\Syswow64\. Therefore this fix was to run the following command at the Run line: -
c:\windows\syswow64\odbcad32.exe

No comments: