>Ok, after more information, the situation we have is that I need to force my application to use the System DSN of the 32 bits version which is in C:\Windows\SysWOW64\odbcad32.exe. So, this is the focus. But, is this something I have control on in my application? The System DNS is already created. It is just that my application, by default, or any other .NET application BTW, uses by default the 64 bits version of the System DSN on a 64 bits OS. So, I have no idea presently what I can change in my Setup.exe to handle this.
Ok, lets provide more information as this is going nowhere.
1. I compile my application on a Windows 7 64 bits OS with .NET Framework 4.0.
2. The application is installed on client sites by the use of Setup.exe which is built from my project.
3. This works well on 32 bits OS clients.
4. It fails on 64 bits OS clients because, by default, my .NET application tries to use the 64 bits version of Odbcad32.exe in %systemdrive%WindowsSystem32 folder. But, it has to use the 32 bits version of Odbcad32.exe in the %systemdrive%WindowsSysWoW64 folder. Yes, I know. The directory naming as well as the files is confusing. But, this is what it is.
5. My Setup.exe, in Configuration Manager, is set up to Any CPU. Any other combinations results in a no compile possibility.
6. So, the goal is to assure that even under a 64 bits OS that the 32 bits version of Odbcad32 will be used. But, how can we control that?