Microsoft Office 2016 Forum

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.

Back to Threads Reply to Thread

How to get ODBC connections working on CrossOver 17.5

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

CodeWeavers or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in our Privacy Policy. You accept the use of cookies or other identifiers by clicking the Acknowledge button.
Please Wait...
eyJjb3VudHJ5IjoiVVMiLCJsYW5nIjoiZW4iLCJjYXJ0IjowLCJ0enMiOi01LCJjZG4iOiJodHRwczpcL1wvbWVkaWEuY29kZXdlYXZlcnMuY29tXC9wdWJcL2Nyb3Nzb3Zlclwvd2Vic2l0ZSIsImNkbnRzIjoxNzA4NjEzODE4LCJjc3JmX3Rva2VuIjoiQUFDZlpSdnh3eEU1ODJUcSIsImdkcHIiOjB9