Bug 146304 - Not able to connect Sqlite database to FlatPak version of LibreOffice Base via ODBC
Summary: Not able to connect Sqlite database to FlatPak version of LibreOffice Base vi...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.2.4.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-18 17:51 UTC by David
Modified: 2022-12-03 12:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David 2021-12-18 17:51:31 UTC
Description:
I previously had a version of LibreOffice (LO) installed from the repository of my distribution. I am running Debian 11. I was able successfully to connect a data source to LO Base and Writer using ODBC to connect an Sqlite database for MailMerge. This worked perfectly. I decided to remove the version of LO I had installed and to install the FlatPak version. Now I am unable to establish an ODBC connection. When I try to set up a connection to an ODBC database, I get the following error message.

"Could not load the program library libodbc.so or it is corrupted.The ODBC data source selection is not available."

I have checked my ODBC setup and nothing has changed since it was working perfectly with the previous set-up of LO that I had. I have installed Flatseal, and I have tried changing various permissions but nothing I do seems to make any difference.


Steps to Reproduce:
1.Open LibreOffice Base and try to set up an ODBC connection to an Sqlite database.
2.
3.

Actual Results:
I get the following error message:

"Could not load the program library libodbc.so or it is corrupted.The ODBC data source selection is not available."

Expected Results:
An ODBC connection to the database should have been established.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:

Information from menu Help - About LibreOffice
================================================
Version: 7.2.4.1 / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Flatpak
Calc: threaded


OpenGL Information
===================
xx@dxx-pc:~$ glxinfo | grep OpenGL
OpenGL vendor string: Intel
OpenGL renderer string: Mesa Intel(R) HD Graphics 530 (SKL GT2)
OpenGL core profile version string: 4.6 (Core Profile) Mesa 20.3.5
OpenGL core profile shading language version string: 4.60
OpenGL core profile context flags: (none)
OpenGL core profile profile mask: core profile
OpenGL core profile extensions:
OpenGL version string: 4.6 (Compatibility Profile) Mesa 20.3.5
OpenGL shading language version string: 4.60
OpenGL context flags: (none)
OpenGL profile mask: compatibility profile
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 3.2 Mesa 20.3.5
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.20
OpenGL ES profile extensions:
Comment 1 sockseight 2022-12-03 08:07:39 UTC
could you please install the latest version of LO FlatPak, with all the required softwares too and clarify if this issue is still seen.

this bug is being set to NEEDINFO.

please get back if the issue is seen again and set the bug status to UNCONFIRMED.


Hello,

Thank you for reporting the bug. Can you please confirm if the issue still exists in the latest build?


Could you please try to reproduce it with a master build from https://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build.
Comment 2 Buovjaga 2022-12-03 12:43:35 UTC
Please report it to Flathub: https://github.com/flathub/org.libreoffice.LibreOffice/issues