Skip to content

Connection error via Loopback provider if it's the first in the Providers parameter #8644

@paradox1307

Description

@paradox1307

firebird.conf contains following providers: Providers = Loopback,Remote,Engine14.
If the data source is specified without a server execution of the block below fails:

execute block returns(res bigint) as
begin
    execute statement 'select 1 from rdb$database' 
    on external data source '/tmp/external.fdb' 
    as user 'SYSDBA' password 'masterkey' into :res;
    suspend;
end^

RES 
===================== 
Statement failed, SQLSTATE = 42000
Execute statement error at attach :
335544472 : Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Data source : Firebird::/tmp/external.fdb

If server is specified ('localhost:/tmp/external.fdb'), the script is executed successfully.

Metadata

Metadata