On 9-5-2019 14:01, Peter Milesson [email protected] [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 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
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/OpenOffice.org. Mark -- Mark Rotteveel
