Re: [libreoffice-users] Failed connection to MySQL database

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: users+unsubscribe@global.libreoffice.org
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