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.

English
, ,
#1

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

#2

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

#3

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.

#4

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

#5

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:

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