Tuesday, 9 March 2010

32-bit odbc on 64-bit Windows

Scenario - our new web cluster is running 64-bit version of Windows Server 2008, and I want to set up a 32-bit ODBC driver (Intersystems Cache since you ask).

However after I'd installed the ODBC driver software, it still wasn't showing up in the Data Sources (ODBC) app.

However in the %systemroot%\syswow64 directory there is the 32-bit version of the ODBC setup application ODBCAD32.exe - and that allowed me to set up the 32-bit driver successfully.

Once again proving the bizarre fact on 64-bit Windows that you need to look in the syswow64 directory to find any legacy 32 bit programmes you might need.

0 comments: