Following Java update, cannot access MySql Database

English
, , , ,
#1

I am running LO5.2.2, on a 64bit windows PC and have just update to JRE1.8.0_111.
Now, whenever I open my base file, and try to see the tables (via Mysql), I get error message:

“The Connection to the data source “Mysql Bookings” could not be established.
The driver class ‘com.mysql.jdbc.Driver’ could not be loaded.”

Any clues to what I need to do now?

NB I have just realised the error message came up before updating Java! Could it be related to a Windows Update?

SOLUTION: Class path to Connector J was missing
After selecting correct Java Runtime Environment, (tools>options>advanced) click on Class Path, and navigate to correct connector-J ‘Jar’ file, select it and click ok

#2

“Class path to Connector J was missing After selecting correct Java Runtime Environment, (tools>options>advanced) click on Class Path, and navigate to correct connector-J ‘Jar’ file, select it and click ok”

(Just providing your answer where it should be. BTW I had this exact same problem, and was just about to answer it but you got here first. :slight_smile:

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.