Yes, that's right, is forwarded and take the database properties, but the engine that is controlling it is the embedded and so, for example, block the file and take exclusive access to it.
I know I can (I should) change the embedded to Classic and so it take its own thread, but in this case, the behaviour of the database is not exactly the same as is one thread controlled by the server.
Both, the embedded and the server side are Firebird 3.0
Juan C.
On 02-08-2022 09:42, bdecharly wrote:
Yes, that's right, is forwarded and take the database properties, but the engine that is controlling it is the embedded and so, for example, block the file and take exclusive access to it.
Then it isn't forwarded to the server, which suggests you have a custom configuration for Providers, or your connection string is not actually server:database, but just database.
I know I can (I should) change the embedded to Classic and so it take its own thread, but in this case, the behaviour of the database is not exactly the same as is one thread controlled by the server.
Both, the embedded and the server side are Firebird 3.0
What is the configuration of Providers in the firebird.conf of your embedded process?
I've tried the default configuration, and also just "Providers =
Remote" in the firebird.conf file.
Also I've tried "ServerMode = SuperClassic" and "ServerMode = Classic"
Regards
Juan C.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/353C4B32898642F0BB4C3FE68B3F955E%40MARTIJNWS.
Simply run
SELECT * FROM MON$ATTACHMENTS
And look at e.g. MON$REMOTE_PROTOCOL
Regards,
Karol Bieniaszewski
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/8ce10711-8e5d-8300-ef50-d42d79e6ca66%40gmail.com.
On 02-08-2022 10:02, bdecharly wrote:
El 02/08/2022 a las 9:45, Mark Rotteveel escribió:
On 02-08-2022 09:42, bdecharly wrote:The connection string is "DESKTOP-FA13C2/3050:C:\Users\JC\Documents\Facturacion\FACTURACION.FDB", but I've tried too "DESKTOP-FA13C2:facturacion" with "facturacion = C:\Users\JC\Documents\Facturacion\FACTURACION.FDB" in server side /databases.conf/ and the result is the same
Yes, that's right, is forwarded and take the database properties, but the engine that is controlling it is the embedded and so, for example, block the file and take exclusive access to it.
Then it isn't forwarded to the server, which suggests you have a custom configuration for Providers, or your connection string is not actually server:database, but just database.
As far as I'm aware, Engine12 (the embedded engine) wouldn't even be able to open a database passed that way, so it would forward to the next provider (and with the default config, it would be handled by the Remote provider, so should never be handled by Engine12).
Also, echoing what Elmar already said, why is your client process even able to access a database file that should be managed by the server.
I know I can (I should) change the embedded to Classic and so it take its own thread, but in this case, the behaviour of the database is not exactly the same as is one thread controlled by the server.
Both, the embedded and the server side are Firebird 3.0
What is the configuration of Providers in the firebird.conf of your embedded process?
I've tried the default configuration, and also just "Providers = Remote" in the /firebird.conf/ file.
Also I've tried "ServerMode = SuperClassic" and "ServerMode = Classic"
Are you sure you're modifying the *right* firebird.conf? You need to modify the firebird.conf that is in the same directory as the fbclient.dll that is loaded by your application.
Regards
Juan C.