Flatpak install of LO cannot connect to SQLite database
Moving from the default LO version in Ubuntu 20.04 to the flatpak version (currently 7.0.0.3) I cannot connect to an sqlite3 database. Double-clicking the .odb database file in the file manager opens Base on the "Forms" button, then clicking on "Tables", an error dialog appears:
Libreoffice Base
The connection to the data source "Adresses" could not be established.
libodbc.so /run/build/libreoffice/connectivity/source/drivers/odbc/- ODriver.cxx:100
The "More" button does not reveal much more information. It lists two errors:
The connection to the data source "Adresses" could not be established.
and
Error code: 1000
libodbc.so /run/build/libreoffice/connectivity/source/drivers/odbc/ODriver.cxx:100
No need to say that the database was correctly configured for access under the regular *.deb version (6.4.5).
Anyone knows if and how the flatpak version can be set to connect to an sqlite database through odbc?
I'm new to LO Flatpak myself. Advice received elsewhere warned me about possible problems with file access for containerised Flatpak software. Flatseal can be used to tweak file access permissions of Flatpak apps. It might be worth a try. https://flathub.org/apps/details/com....