Hi Harvey,
I am running mariadb 10 on the backend. File mysql-connector-java.jar is registered under Options -> LibreOffice -> Advanced -> Class Path at /usr/share/java/
For MariaDB I would use the JDBC-connector fro MariaDB, not from MySQL. You could get the connector form here: https://downloads.mariadb.com/Connectors/java/ Connection to: org.mariadb.jdbc.Driver For connecting with drivers since version 3.0. you have to add ?permitMysqlScheme to the database name test?permitMysqlScheme will be the connection string for the database 'test'.
I'm not sure I follow what you saying about connection change. I haven't changed the connection parameters nor the method. I have tried setting up the database with an alternative connection method (i.e 'Direct'). That succeeds, but I need to transfer all my macros, queries, forms and reports from the old .odb to the new one.
Couldn't you change the connection in the file, which had been connected by JDBC?
Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
