Connecting DBeaver to a Firebird file, gives error code 335544721

Question

I'm trying to make DBeaver database manager connect to a Firebird *.FDB file. It is a local file database and I want to inspect the tables etc and perform some queries for data reporting.

However, when I try to open the database in DBeaver I get this error message:

Unable to complete network request to host "localhost".[SQLState:08006, ISC error code 335544721]
Connection refused: connect

I've tried updating the driver, which updates the org.firebirdsql.jdbc:jaybird-jdk18:RELEASE [3.0.5] without any errors, and also enabling/disabling the embedded checkbox.

As far as I know Firebird is supported by DBeaver, what am I doing wrong here?

score 3 · Answer 1 · answered Nov 11 '18 at 21:33

After some trial and error I've figured out the answer to this. The services Firebird Service and Firebird Guardian weren't running. I had installed the Firebird Server but accidentally selected "Run as an Application" instead of "Run as a Service".

DBeaver cannot connect to the Firebird database file without these services running. Which is kind of odd because the osFinancials application that uses this database file was working just fine without the services.

Anyway, once the Firebird Server is installed as "run as application" there is AFAIK no easy way to still get it to run as a service. So I just uninstalled and then reinstalled the Firebird Server setup and selected the correct option.

It adds two services named FirebirdGuardianDefaultInstance and FirebirdServerDefaultInstance which correspond to these two commandlines:

"C:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbguard.exe" -s DefaultInstance
"C:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbserver.exe" -s DefaultInstance

score 0 · Answer 2 · edited Dec 05 '19 at 15:27

0

There is the possibility of the version of the driver being incompatible with the version the (remote) server is using. You can try upgrading (or downgrading) the version by downloading the appropriate version:

Dbeaver upgrade/downgrade driver version

edited Dec 05 '19 at 15:27

MMM

3,257

answered Dec 05 '19 at 14:50

Elm Enog

1

MAndreato · Answer 3 · 2024-05-11T15:44:08.697

0

On Windows, it's not necessary to run Firebird as a service --> just run "Firebird service" as administrator by right clicking its icon and selecting "execute as administrator". DBeaver should be able to connect to the local file. Sample connection snapshot - sorry, not in english

edited May 11 '24 at 15:44

answered May 11 '24 at 15:43

MAndreato

1

score -1 · Answer 4 · edited Mar 13 '23 at 06:27

-1

Service "Firebird" must be active:

Service "Firebird" must be active

image description

edited Mar 13 '23 at 06:27

Aulis Ronkainen

3,072

answered Mar 12 '23 at 21:52

Alexander Hüls

1
1

Connecting DBeaver to a Firebird file, gives error code 335544721

4 Answers4