Ask Your Question
0

How do I connect to local firebird 3 server from Libreoffice 6.2

asked 2019-05-08 13:18:38 +0200

yorwos gravatar image

updated 2019-05-08 13:25:45 +0200

I installed firebird-3.0 and Libreoffice 6.2 I want to connect libreoffice to external firebird database.

On the database wizard -Select Database Step: on the Connect to an existing database dropdown menu I picked Firebird File --> Next - On the Connection settings it asks for Datasource URL (e.g. host=$host:$port dbname=$database) I know that I can connect with isql tool to my example database with

isql examples -u sysdba -p masterkey

or by using the full path

isql 'localhost:c:\db\examples.fdb' -u sysdba -p masterkey

And work from the Command Prompt.

But I'd like to use Base for the rest. How can I do that?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-05-09 20:12:22 +0200

Ratslinger gravatar image

updated 2019-05-10 02:57:06 +0200

Hello,

Best current method to connect to a Firebird server is using JDBC. For the driver -> Jaybird 3.0. ODBC can be very problematic.

Consider installing FlameRobin for a GUI interface -> Third-party Tools & Drivers

Also, future questions should include your OS and the specific LO version as well as the DB you are dealing with.

edit flag offensive delete link more
0

answered 2019-05-09 13:51:20 +0200

The interface to ask for user and password is not implemented yet : https://bugs.documentfoundation.org/s...

You will need to use JDBC or ODBC for now.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2019-05-08 13:18:38 +0200

Seen: 121 times

Last updated: May 10