execute statement on external database on Dbeaver

[Maurizio Alfani]

Hi.

I use DBeaver 25.2.4.

I open my network DB on 192.XXX.XXX.XXX: trying to execute a SQL block containing the execute statement on a external db results in error message like "unavailable database" or "Unable to complete network request to host "localhost"

The external db is on disk "C:" of my PC.

Could someone point me in the right direction?

Thanks in advance.

Maurizio

P.S.

I add my execute block:

set term ^ ;

execute block
returns(
  POUT varchar(100)
)
as
begin
  execute statement  'select first 1 CS from SOST order by CS'
  on external data source 'localhost:C:\DB_APP MIN\data A\DATA\M.FDB'
  AS USER 'sysdba' PASSWORD 'masterkey'
  into :POUT;
  suspend;
end^
set term ; ^

[Vlad Khorsun]

I open my network DB on 192.XXX.XXX.XXX: trying to execute a SQL block containing the execute statement on a external db results in error message like "unavailable database" or "Unable to complete network request to host "localhost"

  This message most often means that Firebird Server is not running on target host or its network listener is blocked 

(by firewall or other way). 

 

The external db is on disk "C:" of my PC.

  Is it the same host as " 192.XXX.XXX.XXX" above ?

Regards,

Vlad

[Mark Rotteveel]

On 14/11/2025 17:38, Maurizio Alfani wrote:
> Hi.
> I use DBeaver 25.2.4.
> I open my network DB on 192.XXX.XXX.XXX: trying to execute a SQL block
> containing the execute statement on a external db results in error
> message like "unavailable database" or "Unable to complete network
> request to host "localhost"
> The external db is on disk "C:" of my PC.

In an execute block, localhost points to the server host you're
currently connected to, so if 192.XXX.XXX.XXX is a different host than
*your* PC, it will not work as you expect.

> Could someone point me in the right direction?

Use the hostname or external IP address of your machine, assuming it's
even accessible from 192.XXX.XXX.XXX.

Mark
--
Mark Rotteveel

[Maurizio Alfani]

Hi, Vlad. 

  Is it the same host as " 192.XXX.XXX.XXX" above ?

No, it'snt.

Now I understand the problem.

Thanks a lot for your time.

Regards,

Maurizio

[Maurizio Alfani]

Hi Mark.

Thanks a lot for your time.

Best regards,

Maurizio