1
I need some advice as I'm 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 a DSN file to connect to data sources to retrieve data. These work fine on 32bit and 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 or method of getting Excel or the DSN file to NOT use the 64bit driver but force it to use the 32bit driver?
Hi Todda, thanks for the reply regarding my problem, i was aware of being able to install 64bit drivers and getting the system to access them that way, however we are presently testing our systems within TS as a proof of concept before deploying it live.
The idea of having to install the 64bit drivers alongside required 32bit drivers would have meant us re-testing applications to ensure that there was not compatibility problems between the two driver sets. Sadly without wanting to "tinker" with registry settings it appears this is the only real route so we are presently re-testing.. – Kristiaan – 2011-11-22T14:13:08.493