MS Excel 2010 - Using DSN + 32 bit drivers

Posted by Kristiaan on Super User See other posts from Super User or by Kristiaan
Published on 2011-11-21T10:43:07Z Indexed on 2012/10/28 11:07 UTC
Read the original article Hit count: 278

Filed under:

microsoft-excel

|

64-bit

|

32-bit

|

dsn

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.

http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/5108f337-f06a-4518-afe3-d3c1abd040ef/

© Super User or respective owner

Related posts about microsoft-excel

Connecting to Microsoft Excel using Oracle Data Integrator

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more details on these elements, please refer to the ODI Tutorial… >>> More
Connect Microsoft Excel To SQL Azure Database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
A number of people have found my post about getting started with SQL Azure pretty useful. But, it's all worthless if it doesn't add up to user value. Database are like potential energy in physics-it's a promise that something could be put in motion. Users actually making decisions based on analysis… >>> More
How to code Microsoft Excel "Shift Cells Up" feature in SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column… >>> More
a question on using Microsoft Excel to do data analysis

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone there, Me and my mates have been given an Excel spreasheet,which contains the data of the Census report. The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year. We are up to doing some analysis… >>> More
Working with PivotTables in Excel

as seen on How to geek - Search for 'How to geek'
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them. Note: This article… >>> More

Related posts about 64-bit

64-bit 13.10 shows 1GB less RAM than 64-bit 13.04 did

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Multiple 64-bit versions (Kubuntu, Lubuntu and Xubuntu) once installed on my ThinkPad R60 show 3GB of RAM, not the correct 4GB of RAM. Last week with 13.04, I had 4GB of RAM (which matches the BIOS) and this week I have 3GB available. Inquiring minds want to know. Details follow: Linux R60 3.11.0-12-generic… >>> More
VMWare Workstation 6.5.5 (64-bit) on Ubuntu 10.04 (64-bit) Odd Problem

as seen on Server Fault - Search for 'Server Fault'
I managed to successfully install VMWare Workstation 6.5.5 (64-bit) on Ubuntu 10.04 (64-bit). It works well and somehow feels faster and snappier than the same exact version on Ubuntu 8.04. However, there is one slight issue, somewhat hurting productivity: When the guest VM is Microsoft Windows… >>> More
How to build 64-bit Python on OS X 10.6 -- ONLY 64 bit, no Universal nonsense

as seen on Stack Overflow - Search for 'Stack Overflow'
I just want to build this on my development machine -- the binary install from Python.org is still 32 bits and installing extensions (MySQLdb, for example) is driving me nuts with trying to figure out the proper flags for each and every extension. Clarification: I did NOT replace the system Python… >>> More
Windows 7 on a 64-bit computer

as seen on Super User - Search for 'Super User'
I read on Wikipedia that Windows 7 on a 64-bit PC needs twice as much RAM as on a 32-bit PC. I understand why is that: every number stored in memory takes 8 bytes rather than just 4. That, in simple terms, means that your amount of RAM is reduced to half when you use Windows 7 on a 64-bit computer… >>> More
ActiveX component can't create Object Error? Check 64 bit Status

as seen on West-Wind - Search for 'West-Wind'
If you're running on IIS 7 and a 64 bit operating system you might run into the following error using ASP classic or ASP.NET with COM interop. In classic ASP applications the error will show up as: ActiveX component can't create object (Error 429) (actually without error handling the… >>> More