I need some advice as im running into a problem and so far i have been unable to find a solution.
We have a set of reports developed in MS Excel that use DSN file to connect to data sources to retrieve data, these work fine on 32 / 64bit systems, however we are moving to a terminal server environment using windows 2008 R2 64Bit.
The reports fail to run using the DSN's within this environment if we only have the 32bit drivers installed and configured in the ODBC settings, the minute we install the 64Bit drivers the software works.
Is there a way / Method of getting Excel or the DSN file to NOT use the 64Bit driver, but force it to use the 32bit driver.
ANSWERED - But due to low user score i cannot "answer" my own question...
Sadly there is no way to-do what i want to-do, without a lot of very nasty and not 100% perfect reg hacks.
If you need to access 32bit ODBC data sources the application in question has to be 32Bit.
here is a link to just one forum post i found relating to this type of problem, it appears the only way i would be able to accomplish this is to remove the 64bit version of office and install the 32bit version instead of it.