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?\
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.