Subject | Re: [firebird-support] Connect Libreoffice Base with Firebird |
---|---|
Author | Peter Milesson |
Post date | 2019-05-09T12:01:26Z |
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:
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.
>