I have been trying to use Base to connect to a local MySQL server. I installed JavaPortable. When you go to Tools > Options > Java, Use a Java runtime environment is selected and under Java runtime environments (JRE) already installed: there is a listing for Sun Microsystems Inc. version 1.6.0_22. I've been reading through the forums and other websites and can't make sense of what I am suppose to do to connect to the database. My last look into resolving this I came across an article that suggested I download a JDBC driver for MySQL. I did download the driver but I am not sure where to plug it into OpenOffice.
When I try to authenticate to the database I get the following error message:
The driver class 'com.mysql.jdbc.Driver' could not be loaded
If I have left any information out please forgive me, I'm not sure of what else I need to include. Thank you!