Geert Stappers <stapp...@stappers.nl> wrote: > On Sat, Jun 21, 2025 at 05:58:30PM +0100, Chris Green wrote: > > Greg Wooledge <g...@wooledge.org> wrote: > > > On Sat, Jun 21, 2025 at 15:37:38 +0100, Chris Green wrote: > > > > I'm trying to install the libraries and drivers required to use a > > > > sqlite3 database with libreoffice writer. However when I try to > > > > install the required packages I get an error:- > > > > > > > > root@t470# apt install unixodbc-dev unixodbc-bin unixodbc > > > > > > Why did you type that command? > > > > Beacause that's what several of the places (admittedly old) that tell > > you what you need to do say that these packages are needed. > > `apt show libreoffice` says unixodbc > is the package for ODBC database support. > Yes, and it's installed.
> For what it is worth: sqlite3 and ODBC are not the same. > Yes, I know that. ODBC is a (sort of) interface specification and sqlite3 is a database 'engine' that works using a file rather than a server. > > > > > Reading package lists... Done > > > > Building dependency tree... Done > > > > Reading state information... Done > > > > Package unixodbc-bin is not available, but is referred to by another > > > > package. > > > > This may mean that the package is missing, has been obsoleted, or > > > > is only available from another source > > > > > > > > E: Package 'unixodbc-bin' has no installation candidate > > > > root@t470# > > > > > > > > So what do I need to do to get this working? Ignoring the error and > > > > continuing fails. > > > > > > > > What I suspect I need is an up to date guide on how to get sqlite3 > > > > working with libreoffice base but I can't find one. All the guides I > > > > can find are many years out of date and I suspect that may be the > > > > reason I'm getting the above error. > > > > > > Oh, you're blindly following some ancient third-party "guide". Well, > > > maybe the packages were merged or something. Does it work if you > > > simply omit the -bin package? > > > > > No, it doesn't work if I just carry on without unixodbc-bin. > > Please elaborate. For https://xyproblem.info reasons. > libreoffice simply doesn't open sqlite3 databases. It tells me the database is corrupt and that's all. -- Chris Green ยท
