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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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_files_.28OpenOffice.org_2.x.29


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

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux