Hello,
I seem to be unable to connect LibreOffice (7.2) Base to a Filemaker database on a local Mac Big Sur (11.5.2).
I have enable ODBC in Filemaker and can connect to the DB in ODBC Manager. (1.0.22) from Actual Technologies. (test connection passes)
When I try connect from LibreOffice it complains about "Could not load the program library libiodbc.dylib or it is corrupted. The ODBC data source selection is not available.”
It seems that “libiodbc.dylib” is missing?
I have spent hours searching the web for answers, no success as yet.
Maybe somebody here can provide some clues, or knows, to fix this problem.
In anticipation - thank you.
Hi, boiling down https://bugs.documentfoundation.org/show_bug.cgi?id=138990
we can find out that ActualTechnologies created a simple utility that will remove the code signing from your installed LibreOffice application, which will allow you to use ODBC.
But if you have already installed libidodbc in /usr/local/lib and if you are comfortable with the commandline, just issue a
/usr/bin/codesign --remove-signature /Applications/LibreOffice.app
The other possibility :
download and install
http://www.actualtech.com/downloads/libreoffice_unsigner.dmg
which installs also the files in /usr/local/lib if they are not present
AH, thank you for the help.