Friday, 20 November 2009

32bit Application using ODBC on Windows 2008 r2 64

If you are having problems with your application connecting (even though the odbc entry says it connects fine) it could be you need to add a 32bit ODBC entry as the one the system created using the normal tools is a 64bit ODBC driver.

To do this use the following program (remember to remove the 64 bit entry first!)...

%SystemRoot%\SysWOW64\ODBCad.exe    (normally c:\Windows\SysWOW64\ODBCad.exe)

There are numerous 32bit routines (such as regedit) that work on the 32bit area of the registry.

No comments: