Re: unixodbc-bin is not available - what to do?
Geert Stappers <stappers@stappers.nl> wrote:
> On Sat, Jun 21, 2025 at 05:58:30PM +0100, Chris Green wrote:
> > 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.
>
> `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
·
Reply to: