Trying to open a .odb file in newest version of Base and get the error SQL Status: HY000 The connection could not be created. May be the necessary data provider is not installed.

Windows 10
LibreOffice Version: (x64)
Do not remember the ver of base .odb file created
Have not found any posts that help

Need more info. Is correct Java installed & settings correct and verified? What database is this connected to? Have you modified any database path settings?

If the problem was caused by corrupt files in an embedded setup, perhaps you could salvage it by unzipping the .odb, extracting the HSQL db and setting it up as a split db, which should have been done to begin with.

Also, the title of the question is too long. See guidelines for asking.

Old question, but today I encountered:
The connection to the data source “TEST_DATABASE” could not be established.

Under “More” the info was:

–begin quote–

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’. /build/libreoffice/parts/libreoffice/build/connectivity/source/commontools/dbexception.cxx:399

A connection for the following URL was requested “sdbc:embedded:hsqldb”.

–end quote–

It turned out that no Java Runtime Environment (JRE) had been selected in Tools/Options under LibreOffice/Advanced.

After selecting the only JRE listed, it worked.

Without the documentation I probably would have been lost :slight_smile: