Subject Re: [firebird-support] Connect Libreoffice Base with Firebird
Author Peter Milesson
Hi Mark,

Your suggestion doesn't work for me. The error message is:

A driver is not registered for the URL firebirdsql:oo://<server>//<path_to_database.fdb>.

Best regards,


On 09.05.2019 17:41, Mark Rotteveel mark@... [firebird-support] wrote:

On 9-5-2019 14:01, Peter Milesson miles@... [firebird-support] wrote:
> Hi folks,
> I have used LibreOffice base with the JDBC-connector. Install Java, and
> then install the required components of Jaybird (jaybird-full-3.0.5.jar,
> connector-api-1.5.jar, antlr4-runtime-4.7.1.jar). Jaybird can be
> downloaded from I use OpenJDK 8
> for Windows from Azul systems (
> It's free to download and use, compared to Oracle Java. It works well
> enough.
> Register the .jar files in LibreOffice, Tools->Options->Advanced->Class
> Path and use Add archive.
> When setting up the Base Databse for JDBC, the following must be entered:
> Data source: firebirdsql://<server>//<path_to_file.fdb>
> JDBC driver class: org.firebirdsql.jdbc.FBDriver

It would be better to use firebirdsql:oo://<server>//<path_to_file.fdb>

The firebirdsql:oo: sub-protocol addresses some problem with metadata
when used with LibreOffice/

Mark Rotteveel