Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 9-5-2019 21:46, Peter Milesson mi...@atmos.eu [firebird-support] wrote: > Your suggestion doesn't work for me. The error message is: > > A driver is not registered for the URL > firebirdsql:oo:. If you can connect with firebirdsql:/// then you can also connect with firebirdsql:oo:///

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-10 Thread Peter Milesson mi...@atmos.eu [firebird-support]
Hi Drew, What you describe, is exactly how my JDBC connector is set up since ancient times, and what I suggested to the OP. I always use the latest production Jaybird, Java (OpenJDK8) and LibreOffice. My standard data source is jdbc:firebirdsql:, and driver is

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Drew Jensen drewjensen.in...@gmail.com [firebird-support]
Right - not finding the class path. OK, you will need to tell LibreOffice where that JDBC driver is located first. To do that: In LibreOffice select menu Tools->Options Open the LibreOffice section in the dialog box and select Advanced. On this dialog along with selecting your flavor of Java you

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Peter Milesson mi...@atmos.eu [firebird-support]
Hi Mark, Your suggestion doesn't work for me. The error message is: A driver is not registered for the URL firebirdsql:oo:. Best regards, Peter On 09.05.2019 17:41, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 9-5-2019 14:01, Peter Milesson mi...@atmos.eu

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 9-5-2019 14:01, Peter Milesson mi...@atmos.eu [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

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Peter Milesson mi...@atmos.eu [firebird-support]
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

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2019 13:03, Drew Jensen drewjensen.in...@gmail.com [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

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Drew Jensen drewjensen.in...@gmail.com [firebird-support]
Howdy, On Wed, May 8, 2019 at 8:48 PM Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote: > > > On 08/05/2019 21:46, Drew Jensen drewjensen.in...@gmail.com > [firebird-support] wrote: > > > > What you want to do is to choose ODBC or JDBC if you want to connect to > > a FireBird

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-08 Thread Scott Morgan bl...@blueyonder.co.uk [firebird-support]
On 08/05/2019 21:46, Drew Jensen drewjensen.in...@gmail.com [firebird-support] wrote: > > What you want to do is to choose ODBC or JDBC if you want to connect to > a FireBird server instance. > What is the reason they don't have direct connection to FB servers as an option? They've already got

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-08 Thread Drew Jensen drewjensen.in...@gmail.com [firebird-support]
Howdy, https://ask.libreoffice.org would be a better place however. "Firebird File" is not the Base sdbc driver you want here. Firebird File, is a Base driver which uses Firebird Engine12 to talk to a single user .fdb (usually created from within Base) file external to the Base .odb file.

[firebird-support] Connect Libreoffice Base with Firebird

2019-05-08 Thread garna...@yahoo.gr [firebird-support]
I installed firebird server and libreoffice Base 6.2 On the database wizard I proceeded like: -Select Database Step: -on the Connect to an existing database dropdown menu I picked Firebird File and clicked Next - On the Connection settings it asks for Datasource URL (e.g. host=$host:$port