Hi, on Windows and using LibreOffice 6.3, I now have a working LibreOffice Base program that uses an embedded Firebird database. I am in the process of substituting the embedded server with a Firebird 3.0 server. The Firebird server is now working and I am able to access it through LibreOffice and SDBC. I have also installed FlameRobin as the GUI for Firebird.
In the tests that I have done, I connect through the LibreOffice database wizard using JDBC to a database (test.fdb) previously created using FlameRobin . This results in a test.odb file which when opened in LibreOffice lets me get to the database test.fdb. The trouble is that LibreOffice prompts me for a username and password for test.fdb
This is not though what I want. I want to be able to open the test.odb file and “automatically” connect to the appropriate
Firebird database in a transparent way, just like when using an embedded database. I presume that I need to write a macro that connects to the test.fdb database and passes username and password.
Can you please help me with this macro, and indicate where to include it in LibreOffice? Thanks.