Base : SQL Status: HY000

[ocayatte]

Hello,

I have just installed Libreoffice 5.1.5.2

I am on Mac OSX 10.11.6, Java Version 8 Update 101

I can open my base but when I try to open a form I get the following error :

SQL Status: HY000

The connection to the external data source could not be established. No SDBC driver was found for the URL ‘sdbc:embedded:hsqldb’.

[shade7156]

In my case I have java installed and also marked in Tools > Options > Advanced.
Since I did the minimal install for ubuntu, I guess something might have missed there

open terminal and run sudo apt install libreoffice-sdbc-hsqldb. And then it worked for me

[mariosv]

I think the answer is in this thread:

Base error message - connection driver

I have been working with a Base database I created, but recently started getting these error messages when I attempt to open the main table. “The connection to the data source could not be established. Error code: 1000. The driver class " could not be loaded. SQL status: HY000.” On the main database page it says JDBC on the bottom left side. This is a bit surprising to me, as the database was created using Libre Office 4.2.1 running under Windows 7. Also I don’t understand what the error me…

[ocayatte]

Thank you !