|Subject||Re: [firebird-support] Connect Libreoffice Base with Firebird|
On Thu, May 9, 2019 at 3:48 PM Peter Milesson miles@... [firebird-support] <firstname.lastname@example.org> wrote:
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>.
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 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
> 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.