Biblioteca

How to make Firebird 3 connect like 2.5 with embedded connection string

As you know, Firebird 3 connects to the database as an embedded server, if you specify the following connection string:

C:\HQbird\Firebird30>isql -user SYSDBA -pass masterkey d:\30test.fdb
Database: d:\30test.fdb, User: SYSDBA
SQL> select MON$remote_protocol, mon$remote_process, mon$user from mon$attachments;

MON$REMOTE_PROTOCOL MON$REMOTE_PROCESS  MON$USER
===================================================================
<null>                                               <null>                                SYSDBA
<null>                                               <null>                                Cache Writer
<null>                                               <null>                                Garbage Collector


If you want to connect as XNET user, with authentication, the standard way is to specify XNET as a protocol.

C:\HQbird\Firebird30>isql -user SYSDBA -pass masterkey xnet://d:\30test.fdb
Database: xnet://d:\30test.fdb, User: SYSDBA
SQL> set list on;
SQL> select MON$remote_protocol, mon$remote_process, mon$user from mon$attachments where mon$attachment_id=current_connection;

MON$REMOTE_PROTOCOL             XNET
MON$REMOTE_PROCESS              C:\HQbird\Firebird30\isql.EXE
MON$USER                        SYSDBA        ​