Unable to create DSN for Microsoft Office System Driver on 64. Such as connections to Access or Excel, on a 64-bit. Using the 32-bit and 64-bit ODBC. Unicode enabled 32/64-bit ODBC Driver for Mac. Connect to Microsoft Excel data from popular Mac applications like FileMaker Pro and Office for Mac. Just trying to find the Microsoft driver to install the ODBC driver excel 32 bit on a Windows 7 and Office 2013 professional 64 bit. Hi Living Large in LV.
Active4 years, 3 months ago
Installing 32-bit and 64-bit Microsoft Access Drivers next to. Since the 32-bit ODBC driver might not. Which can be downloaded from the Microsoft Download. 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?
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?
nixda
21.9k1111 gold badges8181 silver badges137137 bronze badges
KristiaanKristiaan
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 ta.speot.ista.speot.is
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.
13.6k22 gold badges2727 silver badges4747 bronze badges
OP answered his 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.
Not the answer you're looking for? Browse other questions tagged microsoft-excelmicrosoft-excel-201064-bit32-bitdsn or ask your own question.If you want to import data into Excel for Mac from a database (for example, from FileMaker Pro), you need an Open Database Connectivity (ODBC) driver installed on your Mac. The driver you get depends on which version of Excel for Mac you have.
Excel 2016 and laterExcel for Mac 2011
The instructions below apply to Excel 2016, 2019 and Office 365 fo Mac.
These versions of Excel do provide an ODBC driver for connecting to SQL Server Databases. On the Data tab, click New Database Query > SQL Server ODBC. Then use the dialog boxes to import the data.
If you are connecting to other ODBC data sources (for example, FileMaker Pro), then you'll need to install the ODBC driver for the data source on your Mac. Drivers that are compatible with Excel for Mac are available from these companies:
Microsoft Excel 2016 Odbc Driver 32 Bit Download
Important: As of August 2016, Excel 2016 for the Mac was updated from 32-bit software to 64-bit software. To see if you have this update, click the Excel menu > About Excel. If you have version 15.25 or later, you have the 64-bit version.
The 64-bit update helps Excel run faster, and makes it more reliable when working with very large files. However, if you are using a 32-bit ODBC driver from one of the companies listed above, it may cause Excel to crash when connecting. To avoid this, install a 64-bit driver from the company’s website. Excel 2010 32 Bit Download
This version of Excel does not provide an ODBC driver. You must install it yourself. Drivers that are compatible with Excel for Mac 2011 are available from these companies:
After you install the driver for your source, you can use Microsoft Query to create new queries or refresh existing queries that were created in other versions of Excel, such as Excel X, Excel 2004, and Excel for Windows. For more information, see Import data from a database in Excel for Mac 2011.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |