Thursday, April 5, 2012

How to create 32bit ODBC DSN in 64bit Operating System

We have seen this request from one of our user, they required a 32-bit ODBC driver to run their application. Below are the steps to create 32-Bit DSN in 64-Bit Server.
We can create this DSN using a folder which is located at C:\windows\SysWow64 folder wherein WoW64 stands for “Windows on 64bit Windows” and this folder contains all the 32-bit binary files, which run on the top of the 64-bit windows. It looks like a double copy of everything in system-32 (which actually is 64-bit binaries).
In WoW64 folder there is an executable file, odbcad32.exe which helps us to create 32-bit DSN on 64-bit operating system.

No comments: