How to do you open a firebird embedded Database in LO 25.8
The database opened no problem in LO 6.4
I still have a woking copy on a Win 10 laptop( with LO6.4 ) but would like to use it on a Win 11 laptop with LO 25.8
Version: 25.8.2.2 (X86_64)
OS: Windows 11 X86_64 (build 26200)
Thanks that solves that problem but it has given me a new problem
I can now create ( in LO25.8 ) new firebird embedded Database and
will also convert HSQLDB embedded to firebird that were created in LO6.4
But what I still cannot do is copy across an old firebird embedded file from LO 6.4 in win 10 to LO25.8 in win 11 ( but i can do it for the HSQLBD )
I can use existing Firebird databases without experimental features enabled. I can even create new Firebird databases that are not embedded (which is the better choice anyway). The experimental option makes embedded FB the default for new databases (which is the worst option, IMHO).
What does actually happen when you open this database document with embedded Firebird?
relations2listboxes_FB.odb (73.0 KB)
I can see all your tables, but on my LO6.4 tables the tables show no data
Upload your database document, please.
At least, there is a database embedded. The detailed error message goes like this:
Error code: 1
firebird_sdbc error:
*arithmetic exception, numeric overflow, or string truncation
*string right truncation
*expected length 10, actual 15
*gds_$send failed
*Exiting before completion due to errors
caused by
‘isc_service_query’
I have no idea how to fix this binary blob named firebird.fbk which is embedded in the Base document.
ok thanks. I guess I have a very long cut and paste job ahead of me
Yes, same to me here now on another machine:
24.2.7.2 (X86_64) / LibreOffice Community
OS = Ubuntu 4:24.2.7-0ubuntu0.24.04.4
Do it in an external DB.
firebird3.0-utils is a toolset to backup/restore/repair firebird databases. I don’t have time nor inclination to try out.
Thanks, I’ll give it a go.