Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

There are a number of possibilities as to the cause. Without the actual .odb I could not tell for certain.

Please look at my answer in this post for some possible solutions. If you can't figure it out, the actual .odb is needed for further evaluation.

If this answers your question please click on the ✔ (upper left area of answer).

Hello,

There are a number of possibilities as to the cause. Without the actual .odb I could not tell for certain.

Please look at my answer in this post for some possible solutions. If you can't figure it out, the actual .odb is needed for further evaluation.

Edit:

Also based on the last comment, it appears you have modified the Class Path for HSQLDB in Tools->Options->LibreOffice->Advanced. This may be the cause of your problems. This would create a DB based upon the pointed to version but when trying to re-open, LO is looking for HSQL embedded v1.8 - not proper way of using newer version of HSQL.

If this answers your question please click on the ✔ (upper left area of answer).

Hello,

There are a number of possibilities as to the cause. Without the actual .odb I could not tell for certain.

Please look at my answer in this post for some possible solutions. If you can't figure it out, the actual .odb is needed for further evaluation.

Edit:

Also based on the last comment, it appears you have modified the Class Path for HSQLDB in Tools->Options->LibreOffice->Advanced. This may be the cause of your problems. This would create a DB based upon the pointed to version but when trying to re-open, LO is looking for HSQL embedded v1.8 - not proper way of using newer version of HSQL.

Edit 1/13/2018:

First I would ask that you re-read my above answer & provided info in the link. It is completely relevant.

The further information provided in the question is not going to change the answer. The LO version your are using today seems to be working correctly. However, when the inoperable .odb files were created, they were done so most likely with a different HSQL being pointed to thus making them incapable of being opened as embedded files. The link above states how to possibly repair them.

As for using both as embedded DB's in the same system, it can't be done (unless you compile & configure your own version of LO). Regardless of settings, if LO views the settings in the .odb as other than HSQL v1.8, it rejects them with the error of being generated by a new version of the database.

If this answers your question please click on the ✔ (upper left area of answer).