Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Easy connection to remote database

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). ?

Easy connection to remote database

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 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). ?