There's always one.
Unfortunately I have one specific ODBC driver to access an Informix database that our company's ERP software runs upon.
Excel has no problems with it, nor does Crystal Reports.
LibreOffice lets me set up an ODBC connection to it via "Base", but despite telling me that I have successfully connected to the ODBC source, it doesn't see any of the database tables. No error messages of any sort, just a blank list.
Our overseas supplier requires us to submit purchase orders using their password format locked Excel template, complete with hidden macros.
(Their incoming order processing bot spits out any order that doesn't comply with the exact template layout.)
These circumstances pretty much paint me into a corner, as I can't get to the Informix data using LibreOffice.
(The same supplier is now heavily pushing the use of SharePoint. The misery never ends!)
Biting the hand that feeds IT
