Re: FC8: Using Sqlite3 in OpenOffice, with or without ODBC

[Todd Denniston]

M. Fioretti wrote, On 07/22/2008 01:35 AM:
>  On Mon, Jul 21, 2008 16:41:28 PM -0400, Todd Denniston wrote:
> > M. Fioretti wrote, On 07/21/2008 03:06 PM:
>  
> >> I'm having problem to find applicable documentation which explains
> >> how to connect to, and manage, an Sqlite 3 database with OpenOffice
> >> 2.3 on Fedora 8...  there are several resources online, but they
> >> really look all outdated or not valid for some other reason with
> >> OOo 2.x / FC. This page, for example:
> >>
> >>
> http://grass.osgeo.org/wiki/Openoffice.org_with_SQL_Databases#SQLite_file...
> >>
>  
> >> says that I should add the driver libsqlite3odbc.so to
> >> /etc/odbcinst.ini, but I haven't found any rpm which provides this
> >> file.
> >>
> > rpm -q --whatprovides /etc/odbcinst.ini
> > unixODBC-<version>
> >
> > so I suspect you'll want to
> > yum install unixODBC
> >
> >
>  
>  sorry for the confusion, but unixODBC was already installed. It is the
>  sqlite ODBC driver (the one which should contain libsqlite3odbc.so)
>  that seems to have no rpm whatever for fedora.
>  
> > you may need to install something like sqlite3-odbc (name mangled
> > from the fact that for postgresql I needed postgresql-odbc on the
> > machine)...  looking in the Everything tree for 8, looks more like
> > you might one or more of:
> >
> > mysql-connector-odbc
> > php-odbc
> > unixODBC
> >
>  
>  I had already gone through all this reasoning, guesswork and search by
>  myself before my first posting. The first package isn't relevant (it's
>  mysql, not sqlite), the second isn't necessary (php can talk to sqlite
>  through other packages, see the other thread I started yesterday) and
>  it wouldn't be enough anyway for the same reason why the last package
>  (which has always been installed) isn't: the missing piece (=rpm) is
>  "unixodbc <->sqlite" not "Ooo, php, mysql, whatever <->
> unixODBC"
>  
>  so the problem may be restated as: is it true that there is no rpm
>  package for adding sqlite3 support to unixODBC in Fedora 8 (or later)?
>  Or at least for adding sqlite3 support to OpenOffice only, without
>  going through ODBC?
>  
>  THanks,
>  					Marco 
http://www.google.com/search?hl=en&q=sqlite3+odbc&btnG=Google+Search
http://www.ch-werner.de/sqliteodbc/

yum -C info *odbc* |grep -i lite
shows no output, so you'll have to build from source.

Assuming you A) trust the web and B) trust Christian Werner (and me for that 
matter :)

[you may need to install a devel package or two, like for unixODBC, to make 
this work]

get: http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.77-1.src.rpm

if ! [ -e  ~/.rpmmacros ] ; then
cd ; echo "%_topdir `pwd`/builds/rpmbuild" >  ~/.rpmmacros
fi
MYTOPDIR=`grep _topdir ~/.rpmmacros |awk '{print $2}'`
rpmdev-setuptree
rpm -ivh sqliteodbc-0.77-1.src.rpm
cd $MYTOPDIR/SPECS
rpmbuild -bb *.spec # I hope you only have the
#spec for sqliteodbc here.
#
#
# as root, install the resulting rpm's or install the
#complained about devel packages and redo the rpmbuild step.

BTW you'll probably want to look at their documentation sometime: 
http://www.ch-werner.de/sqliteodbc/html/index.html

Of course I did not Google for sqlite3 and OpenOffice.org, so there may be 
other ways. :)

-- 
Todd Denniston
Crane Division, Naval Surface Warfare Center (NSWC Crane)
Harnessing the Power of Technology for the Warfighter