FC8: Using Sqlite3 in OpenOffice, with or without ODBC

[M. Fioretti]

This is related to the problem with Sqlite3 and php I posted earlier
today. I am working with Sqlite3 because I'd like to have single-file,
server-less databases which may be used both from php and from
OpenOffice.

The Php part is now solved, but 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.

By "applicable" I mean that 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.

What now? (please note, as I said in the php/sqlite post, that for
several reasons compiling from source now on this PC is not possible,
sorry).

TIA,
			Marco
-- 
Your own civil rights and the quality of your life heavily depend on how
software is used *around* you:            http://digifreedom.net/node/84

[Todd Denniston]

M. Fioretti wrote, On 07/22/2008 12:28 PM:
>  On Tue, Jul 22, 2008 10:12:24 AM -0400, Todd Denniston wrote:
>  
> > yum -C info *odbc* |grep -i lite
> > shows no output, so you'll have to build from source.
>  
>  as I mentioned at the beginning, I have no possibility to build from
>  source on this computer right now, but thanks for the great summary,
>  I'll use it as soon as possible.
>   
Do you not have another F8 box around some where?
[About to assume you are new to fedora, please forgive.]
If you have another F8 box you could do the build there and transfer the rpm's 
over with a USB stick (or CD or DVD or [shudder] floppy) and just do the 
install portion (rpm -ivh) on the final machine.  And for most internet facing 
servers having the build environment on another system is IIRC considered a 
bit more secure.

> > Of course I did not Google for sqlite3 and OpenOffice.org, so
> there
> > may be other ways. :)
>  
>  I did, and no, there aren't other ways, not in plain view anyway.
>  
>  Thanks,
>  			Marco 

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

[M. Fioretti]

On Tue, Jul 22, 2008 13:04:32 PM -0400, Todd Denniston wrote:
>  Do you not have another F8 box around some where? 
no, I haven't, that's the whole problem. I know how to compile from
source and how to build RPMs, it's just that in _this_ specific moment
I only have one linux box available period, and cannot mess with it
(as in "installing dev packages and compiling, even in a virtualized
box")

In the medium/long term, I'll just manage somehow to solve this
problem, so the issue is closed for me now. Thanks again, though!

As a general closing note, I must say I'm surprised that there is no
more pre-packaged support in Fedora for such a popular database.

				Ciao,
						Marco
-- 
Your own civil rights and the quality of your life heavily depend on how
software is used *around* you:            http://digifreedom.net/node/84

[M. Fioretti]

On Tue, Jul 22, 2008 10:12:24 AM -0400, Todd Denniston wrote:

>  yum -C info *odbc* |grep -i lite
>  shows no output, so you'll have to build from source. 
as I mentioned at the beginning, I have no possibility to build from
source on this computer right now, but thanks for the great summary,
I'll use it as soon as possible.

>  Of course I did not Google for sqlite3 and OpenOffice.org, so there
>  may be other ways. :) 
I did, and no, there aren't other ways, not in plain view anyway.

Thanks,
			Marco
-- 
Your own civil rights and the quality of your life heavily depend on how
software is used *around* you:            http://digifreedom.net/node/84

[M. Fioretti]

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
-- 
Your own civil rights and the quality of your life heavily depend on how
software is used *around* you:            http://digifreedom.net/node/84

[Todd Denniston]

M. Fioretti wrote, On 07/21/2008 03:06 PM:
>  This is related to the problem with Sqlite3 and php I posted earlier
>  today. I am working with Sqlite3 because I'd like to have single-file,
>  server-less databases which may be used both from php and from
>  OpenOffice.
>  
>  The Php part is now solved, but 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.
>  
>  By "applicable" I mean that 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


>  What now? (please note, as I said in the php/sqlite post, that for
>  several reasons compiling from source now on this PC is not possible,
>  sorry).
>  
>  TIA,
>  			Marco 
and 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

The following command may be a better friend:
yum -C info *odbc* | less



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

[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