[SOLVED] Opening a Base database

[Keith Sayers]

I am seeking to open an extant Open Office database - OOBirths.odb - part of my genealogy set - with currently upgraded LibreOffice.Base. It does open but goes directly to Forms and when I seek to move to Tables I get an error message : 'The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'.' Would that reference mean anything to anyone here, please?

[Keith Sayers]

Opening a Base database

I am seeking to open an extant Open Office database - OOBirths.odb - part of my genealogy set - with currently upgraded LibreOffice.Base. It does open but goes directly to Forms and when I seek to move to Tables I get an error message : 'The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'.' Would that reference mean anything to anyone here, please?

[Eddy Praet]

Hallo Keith, make sure the libreoffice-sdbc-hsqldb package is installed...
Greetings from Belgium,
Eddy

[claydoh]

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

make sure the libreoffice-sdbc-hsqldb package is installed

[GreyGeek]

You'll also have to turn on a "pool" for the specific database

[Keith Sayers]

Hallo Keith, make sure the libreoffice-sdbc-hsqldb package is installed...
Greetings from Belgium,
Eddy

Thank you - that did it! But I wonder why that package is not automatically included in a full Base upgrade ...

[GreyGeek]

Thank you - that did it! But I wonder why that package is not automatically included in a full Base upgrade ...

It usually is, or at least it was when I installed 20.04, because I never specifically installed it and you can see from my posted picture that it is in my list of dbs.