Excel 32 Bit Odbc Driver Download

  1. Aug 05, 2011  Only 32-bit ODBC drivers are available for Filemaker. Is it possible to get data in Excel 64-bit using a 32-bit ODBC driver?
  2. Only 32-bit ODBC drivers are available for Filemaker. Is it possible to get data in Excel 64-bit using a 32-bit ODBC driver?
  3. Using DSN + 32 bit drivers. Is there a way or method of getting Excel. SQL Server and Oracle and a whole host of other common RDBMS' have 64-bit ODBC drivers.
  4. Where is this driver setup program and where can I download the.xlsx driver? ODBC Data Source Administrator (32-bit).
Bit

Unicode enabled 32/64-bit ODBC Driver for Mac. Connect to SharePoint Excel Services data from popular Mac applications like FileMaker Pro and Office for Mac.

Active4 years, 3 months ago

I need some advice as I'm running into a problem and so far I have been unable to find a solution.

Excel 32 Bit Odbc Driver Download

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.

Excel 64 Bit Odbc Driver Download

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?

nixda
21.9k11 gold badges81 silver badges137 bronze badges
KristiaanKristiaan

Excel 2013 32 Bit Odbc Driver Download

2 Answers

we are moving to a terminal server environment using windows 2008 R2 64Bit.

This per se won't cause you an issue, you have to install the 64-bit version of Microsoft Office 2010. You have to have a good reason for installing the 64-bit version, Microsoft installs the 32-bit version by default on 64-bit machines for a reason - stuff stops working.

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.

No, but for connectivity within Office applications just install the 64-bit version of ACE and make sure your connection strings reference Microsoft Access Driver (*.mdb, *.accdb).

SQL Server and Oracle and a whole host of other common RDBMS' have 64-bit ODBC drivers, so I can't see how between 64-bit ACE and SQL Native Client/ODAC you can't connect to something.

If it still doesn't work, there's a general purpose mechanism for 'proxying' x64 -> x86 via SQL Server linked servers in this forum post. Replace Microsoft.Jet.OLEDB.4.0 and other settings (to make it a linked server via ODBC, rather than ODBC) with your ODBC provider as appropriate.

ta.speot.ista.speot.is
13.6k2 gold badges27 silver badges47 bronze badges

OP answered his own question

Microsoft Excel Driver Odbc Download 32 Bit

Sadly there is no way to-do what i want to-do, without a lot of very nasty and not 100% perfect reg hacks.

Microsoft Excel Driver Odbc Download 32 Bit

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.


Not the answer you're looking for? Browse other questions tagged microsoft-excelmicrosoft-excel-201064-bit32-bitdsn or ask your own question.