Microsoft Office 2016

This is a community forum and not official technical support. — If you need official support: Contact Us

The following comments are owned by whoever posted them. We are not responsible for them in any way.


Reply to Thread Back to Threads

How to get ODBC connections working on CrossOver 17.5
Javier Pérez Montes
Javier Pérez Montes
Posted 2018-09-27 17:20
I recently migrated my old RHEL 6 install to RHEL 7.
On RHEL 6.5 I was using CrossOver 16, Office 2007 plus the internal odbc32 override in order to work through unixODBC.

But as soon as I moved to RHEL 7 I gave Crossover 17.5 a try, and my beloved Office 2007 stopped to work with ODBC connections.
Each time a macro in Excel 2007 opens an ODBC connection I got a "'-2147467259 (80004005)'" error "Error in method 'Open' object  '_Connection'" enabling traces in unixODBC only shows activity but no connection attempt.
Keep in mind that this never happened to me using CrossOver 16, I used sucessfully CrossOver 11 for several years with Office 2000 doing the same tasks.

Well, I wish to mention that there is a solution, not documented in WineHQ, nor here. So I proceed to show it to the audience.

Accidentally I hit the following thread: https://www.sparxsystems.com/forums/smf/index.php?topic=38998.0

And the solution is just in the last message: "... add a library override for library mtxdm to native.  This requires that you reinstall MDAC.  That appears to have fixed the problem."

So, I added the mtxdm library and set it to native in the Wine setup of the bottle. In my case I did not reinstalled MDAC 2.8.

And Bang! All my ODBC connections are working again.

CrossOver Forums: the place to discuss running Windows applications on Mac and Linux

Please Wait...
eyJjYXJ0IjowLCJ0enMiOi01LCJjZG4iOiJodHRwczpcL1wvbWVkaWEuY29kZXdlYXZlcnMuY29tXC9wdWJcL2Nyb3Nzb3Zlclwvd2Vic2l0ZSIsImNkbnRzIjoxNTY4OTgzMzg1fQ==