

Not specifying username and password (ie leaving as user 'sysdba' password 'masterkey' out of the execute statement). To fix this, add Legacy_Auth to the AuthClient setting in nf of the Firebird 3 server (for example set it to AuthClient = Srp, Legacy_Auth) and restart the server.

Firebird 3 cannot authenticate to Firebird 2.5 as Firebird 2.5 only knows about the legacy authentication mechanism. Using this statement, I can get error "Your user name and password are not defined." from Firebird 3 to 2.5 in the following situations:įirebird 3 has a AuthClient 1 configuration that does not include Legacy_Auth. On external data source 'localhost/3051:D:\data\db\testdatabase.fdb' set term # įor execute statement 'select rdb$relation_name from rdb$relations where coalesce(rdb$system_flag, 0) = 0'

I have done some testing with a Firebird 2.5 (2.5.8) and Firebird 3 (3.0.4) on the same server with different ports using the following simple statement (and modifying some parts depending on what I'm testing) to see what kind of connection failures I can produce.
