Having tried unsuccessfully to my remote mariadb from LibreOffice Base under Leap 15.0, I am still having problems under Leap 15.1. My LO version is 6.1.3.2.
The JDBC and ODBC drivers ‘fail to load’.
Can someone please point me in the right direction to troubleshoot this problem systematically?
I have no problem to connect to the remote database with, say, Mysql workbench or phpMyAdmin from the same client desktop, so the database is accessible.
(By the way, this problem is highlighted also in a thread under LEAP 15.0, so please excuse me for opening the thread anew here. I had no success under 15.0 either)
Installation of the mariadb-connector-odbc package was the first thing I checked! It had been there all right.
What needed to be installed for the jdbc alternative was the mysql-connector-java.
However, whereas I can now connect successfully with jdbc to the database, my existing (LO) input forms won’t let me change the data.The form controls are completely deactivated.
Without extensive experience specifically with LO/mariadb but plenty setting up and using various database connections to various RDBMS,
If you’re not able to modify the data, then it’s likely a permissions problem.
You say you are able to connect using MySQL Workbench, use that to query the grants table and specific table objects, and to modify as needed.
It had been there all right.