How to use a 32-bit ODBC driver in Win 2003 x64

[caboclo975]

I am trying to install 32-bit ODBC driver for an application on Win 2003 x64 as there is no 64-bit driver available. I had talked to some of my friends regarding this and suggested me to set up DSN for 32-bit driver by going to "C:\WINDOWS\SysWOW64\odbcad32.exe". I have tried doing that but when i am running the application than DSN doesn't gets recognized. It seems as if the program is looking for 64-bit DSN. I am just running out of ideas, so is there anyone who can help me out in this situation???

[Crespin]

As far as i am aware a 64-bit process cannot load a 32-bit DLL where as a 32-bit process cannot load a 64-bit DLL but 64-bit operating system but remote procedure calls are supported between 64-bit and 32-bit processes. I mean an out-of-process 32-bit COM server can communicate with a 64-bit client on 64-bit Windows and an out-of-process 64-bit COM server can communicate with 32-bit client as well. If you are having 32-bit DLL which is not COM-aware than you can try rapping it in an out-of-process COM server and use COM for communicating to and from a 64-bit process.