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. > > > 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. I wasn't following all **that** blindly! :-) > Does your guide tell you *why* each of these packages was needed? > Probably not.... I doubt if they know! -- Chris Green ยท