<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Hello.<br>
<p>Since LibreOffice version 7.0, when the username/password step
was
added, there is the possibility to connect to a Firebird server
from
Base.</p>
To do this in the Database Wizard you can select "Connect
to an existing database" and "Firebird file".<br>
<p>On step 2, on "Data source URL" you can write
something like "server1:databaseName" or
"server1:/datadir/datafile.fdb".<br>
</p>
On step 3, you should provide a username and password that are
allowed to connect to the database provided in step 2.<br>
<br>
In this way (I think) a "direct" connection is
established, through the Firebird internal driver.<br>
<br>
According to the document
in <a moz-do-not-send="true"
href="https://www.ibphoenix.com/files/Embedded_fb3.pdf"
class="moz-txt-link-freetext">https://www.ibphoenix.com/files/Embedded_fb3.pdf</a>,
the Engine12.dll
library (or libengine12.so), allow the three "providers"
(Remote, Engine12 and Loopback) and the selection of the necessary
one is done depending on the connection string, so that if you use
"server:database" you should be connected by "Remote".<br>
<br>
But, as it seems from the tests I have done, somehow, the
internal driver is modifying this behavior, because the
"server:database" connection should be multi-user, however,
although the connection is correctly established, the database is
locked (as if an embedded connection had been established instead of
Remote) and does not allow editing of the data by multiple users
simultaneously.<br>
<br>
I don't know if this behavior has been implemented this way
intentionally or it is a bug, but in any case, it would be
convenient
to be able to establish a direct connection (with the internal
driver) in Remote mode (and also in loopback mode) which would be an
undeniable benefit for the user who could easily scale from a
Firebird data file to a server and multiuser one, without having to
establish the cumbersome JDBC or ODBC connections.<br>
<p>Are my assumptions correct?, should I report a bug?</p>
<p>Regards<br>
</p>
<div class="moz-signature">-- <br>
<font color="#2a6099"><font face="Liberation Sans, sans-serif"><font
style="font-size: 12pt" size="3"><b>Juan C. Sanz</b></font></font></font></div>
</body>
</html>