DSN 32Bit and 64 Bit Issues

Good Day Sir,
Thanks for your articles on connection strings. They are quite educative and useful for beginners and experienced users.

Please I have an issues that goes as follows:

I have a 32 bit application that runs fine. It uses a UDL file to access the DSN created in ODBC. Now we have a new server with OS Windows Server 2008 R2 (64 Bit). I created the DSN on the 32 bit ODBC in my 64bit machine (C:\WINDOWS\SYSWOW64\odbc32.exe) but my UDL is not seeing my DSN.

What steps do I follow to create my UDL to see my DSN in a 64 bit machine?\

1 answer

For the record and everyone that find this post having similar problems.

Probable your app is running as a 64-bit app on the 64-bit machine and therefore not can see the 32-bit DSN.

Either create a 64-bit DSN or make sure your app is in WoW / 32-bit mode.