Ask Your Question
0

Easy connection to remote database [closed]

asked 2013-09-20 11:42:40 +0200

Georges Dupéron gravatar image

updated 2013-09-20 11:43:02 +0200

I am creating a small libreoffice base "application", and it needs to connect to a remote (centralized) database.

The .odb file will be shared with multiple people that have little technical knowledge, and it would be best if they could simply open the .odb file with a standard installation of LibreOffice, and use it without further configuration (perhaps just supplying the password to connect to the database).

Currently, we use the MySql database backend, and people which want to use the .odb file have to install jdbc or odbc along with some version of Java, and what was supposed to be a "open the attachment and start working now" e-mail is becoming an increasingly complex tutorial on how to install these components that, in my mind, only programmers and database admins should see.

Question

Is there a simple remote database backend in libreoffice base that will connect to a remote database (preferably a freeware/open-source one, which can be installed under linux, but we can probably cope with something windows-only) without requiring any steps from the "user" of the .odb file (other than supplying the database password if needed). ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-27 12:09:25.026468

2 Answers

Sort by » oldest newest most voted
1

answered 2013-09-20 23:08:29 +0200

m.a.riosv gravatar image

Hi @Georges, seems that postgreSQL do not need JDBC or ODBC to connect, take a look in this thread http://ask.libreoffice.org/en/question/459/generic-form-of-url-for-postgresql/

On other hand Firebird will be default database for LIbreOffice in a few months, but the SDBC connector is not finished yet, so it is needed a JDBC or ODBC to connect.

edit flag offensive delete link more

Comments

Thanks for this answer! As a note for other readers, under ubuntu you have to run sudo apt-get install libreoffice-sdbc-postgresql in order to have PostgreSQL appear in the "Connect to an existing database" drop-down menu, and I guess the procedure should be similar for other flavours of linux.

Georges Dupéron gravatar imageGeorges Dupéron ( 2013-10-11 19:01:15 +0200 )edit
0

answered 2014-07-04 07:22:47 +0200

ValerioHB gravatar image

There's a MySql native connector extention than access to mySql serve without jdbc/odbc connectors. Just open your .odb, insert your pwd and you have access to mySql databases and tables... I use it for long time, but it at the moment it doesn't work on LibreOffice 4.1 (linux openSuse 13.1)!!!!!

edit flag offensive delete link more

Comments

Unfortunately the native MySQL connector extension no longer works in recent LibreOffice installs because it was written in 32-bit. Many people these days have a 64-bit operating system and a 64-bit LibreOffice installation. The extension still works if you choose a 32-bit LO installation, but I'm concerned that won't be an option forever. It would be great if someone updated the native MySQL connector to work with 64-bit. Unfortunately I don't have the necessary knowledge to write extensions.

PhLo gravatar imagePhLo ( 2018-11-17 00:55:12 +0200 )edit

Right now I'm going through the major pain of installing a remote MySQL connection - aka with shared hosting, not on my computer. It's a major pain. While connecting to a local MySQL installation via XAMPP in Windows via "localhost" worked like a charm, I get all sorts of connection problems, timeouts, access not allowed, and timezone issues trying to connect to MySQL on a remote server. No one seems to talk about this. People only talk about local MySQL installs.

PhLo gravatar imagePhLo ( 2018-11-17 00:58:01 +0200 )edit

Question Tools

2 followers

Stats

Asked: 2013-09-20 11:42:40 +0200

Seen: 2,909 times

Last updated: Jul 04 '14