Can not connect sqlite database through ODBC

When using the standard distributed package of LibreOffice for Ubuntu 23.10 (v. 7.6.4.1) I get the following message when trying to connect to an sqlite database through ODBC in Calc:

Could not load the program library libodbc.so.1 or it is corrupted The ODBC datasource selection is not avaiiable

I can connect successfully using the AppImage (v. 7.6.3.2)
Seems to be a long-standing problem, but I can’t see a solution anywhere.
Any suggestions?