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