Re: unixodbc-bin is not available - what to do?
Greg Wooledge <greg@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
·
Reply to: