Isc_service_query / can not connect to my LO Base (Firebird) data anymore

English
#1

Hi, I encouter the following problem:

De verbinding met de gegevensbron “…” kon niet tot stand worden gebracht.
(The connection with datasource … could not achieved)

firebird_sdbc error:
*Expected backup version 1…10. Found 11
*Exiting before completion due to errors
caused by
‘isc_service_query’

I made a Base database/file with Firebird. I made this under W10 with LO Base Version:
25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL threaded

I have this file in folder shared via Nextcloud. The file and computer with W10 were closed. I opened then the file on a Linux computer (Kubuntu; Ubuntu 25.04). On this system LO v 25.2.4.3 is installed.

When I want to reopen the file/database on the W10 system again I get the errors mentioned above. The same happens on a W11 machine.

What I have find is that it could depend on a gbak version. But I do realy not now how to solve that (within LO Base).

Any suggestion to solve this weird problem is helpfull.

With regards,
Michiel Firet

#2

Your Linux has a newer Firebird version. And it upgraded the internal backup. And there is no command-line argument in gbak to store to a specific backup version, unfortunately. I’m afraid, you need either to have a backup of your ODB, or continue using it on Linux.

#3

Hi Mike, thank you for your quick respons. I do have a backup on the W10 system. So I can reverse. But how could I know that two systems have two different versions of Firebird and that LO is depending on it? Is there a possibility to bring the Firebird versions on the (three) systems I use in line? I will mark your answer as a solution.

#4

tdf#168143

#5

Thanks,

I will keep W10/W11 and Linux applications seperated until this is solved, and/or I have made the transition to Linux on all my devices. For now, over and out :wink:

With regards,

Michiel Firet

#6

Seems you have installed a separate version of Firebird for your Linux distribution. And this version isn’t Firebird 3.
Uninstall the installed Firebird 4 version on your Linux distribution. LO Base together with Firebird 3 will also work on the Linus system.

1 Like
#8

Nope. Seems that Linux distros move forward, and drop FB3. See Re: Accepted firebird4.0 4.0.5.3140.ds6-11 (source) into unstable

#7

Hi Robbert, I wasn’t aware of different Firebird versions until I run on this issue. How can I check which Firebird version my LO Base is using? And how can I check the Firebird version on my Linux system? Do I understand it right that when there is no seperate Firebird version installed on Linux, LO will use the internal Firebird 3? Thank you for your help.

#9

No. There is no “internal” Firebird 3 in the packages from Linux distro repositories - they are built to use system FB. There is bundled FB in TDF packages, though; I don’t know about packages like snap / appimage.

#11

Couldn’t confirm this. Have OpenSUSE 15.6 here. There is a separate libreoffice-base-drivers-firebird. Firebird server software hasn’t been installed by default. It’s the same for Ubuntu (https://ubuntu.pkgs.org/24.04/ubuntu-universe-amd64/libreoffice-sdbc-firebird_24.2.2-0ubuntu1_amd64.deb.html)

But: You could also install LibreOffice parallel: Installing in parallel/Linux - The Document Foundation Wiki Then you won’t need all this information, because the Firebird driver of LO will be installed in this way.

#12

Firebird SDBC driver is not embedded FB engine, it’s the code that talks to that engine.

#13

There are many people using my internal Firebird database with Linux without any problem. What system do you use where it is running wrong? If there is a Linux distribution, which connects Firebird 4 to LibreOffice this way it is a bug of this special Linux version.

I see: https://ubuntu.pkgs.org/25.04/ubuntu-proposed-universe-arm64/libreoffice-sdbc-firebird_25.2.5-0ubuntu0.25.04.1_arm64.deb.html
… and this will be a bug of the Ubuntu packages in 25.2.5. There shouldn’t appear Firebird 4 as a depending software.

#14

https://packages.ubuntu.com/plucky/firebird-dev

And I assume, that’s just the beginning. Rene (Debian maintainer of LO packages) had that email exchange with Debian maintainer of FB packages in the beginning of this year. The distros that are based on Debian, but have less strict policy (such as Ubuntu) are likely to start producing this kind of problem soon (well, modulo the rarity of “use a FB-based ODB on it and also on Windows” case…)

And no, it is not a bug of that Linux version. LibreOffice can’t dictate that the distro does not upgrade other packages, just because we don’t upgrade. It is our bug. We need to decide something here.

#15

Hi Robert,

I am running Kubuntu 25.04 on one device, W10 on a second and W11 on a third. The W10 and W11 act the same. Kubuntu (which uses Ubuntu?) seems to have a newer Firebird within the LO package. I am not going to install things beside something else. Libreoffice is installed and maintained via the discovery app of KDE Kubuntu, and uses Ubuntu as source. As said earlier, I leave it for now, it becomes to complicated for me. I hope I can find a way to use LO Base interchangeble on the three systems without troubles. I think for now HSQLDB will do.

With regards,

Michiel Firet

#16

I am not amongst them. I always encounter problems with FB.

#10

Thanks all. I will stick to the HSQLDB embedded database which work between the OS and devices. A leave Firebird for what it is for now, to complicated for me when systems are not interchangeble ‘out of the box’. I do understand all the complexity behind it, but it is not my cup of tea. I like to devellop usefull stuff for my self. And hopefully sometimes something someone else could benefit of it. E.g. a marine logbook as a replacement of the one I use now. A winter project :slight_smile: . For me this thread can be closed.

#17

I strongly recommend a stand-alone HSQL instead of embedded HSQL.

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