Subject Re: [firebird-support] Connect Libreoffice Base with Firebird
Author Peter Milesson
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 http://firebirdsql.org/en/jdbc-driver/. I use OpenJDK 8
for Windows from Azul systems (https://www.azul.com/downloads/zulu/).
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

Best regards,

Peter


On 09.05.2019 13:06, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
> 09.05.2019 13:03, Drew Jensen drewjensen.inbox@... [firebird-support] wrote:
>> What is the reason they don't have direct connection to FB servers as an
>> option?
>>
>> No one stepped up to write it.
> It is an office packet. I personally see no point for it to support anything besides
> ODBC which is good enough for most usages.
>