Post by Yama 2002-06-17 01:29:50 on
http://www.osnews.com/ :

Notice how OpenOffice.org does not include a database. This is because
Sun have licensed code from Adabas for the database in StarOffice, and
this code couldn't be used for OpenOffice.org. There is a solution: you
can link OpenOffice.org to any ODBC compliant database (e.g. MySQL), and
it will be used as the back-end for an MS Access-like database GUI.
Instructions for the GNU/Linux version of OpenOffice.org can be found at
http://www.pclinuxonline.com/modules.php?name=News&file=article&sid=2460

Date: Tue, 04 Feb 2003 00:17:49 +1100
From: Mark Williamson mark@cye.com.au
Subject: Looking for OpenOffice Stuff (for a Linux club night at Frankston)
To: luv@luv.asn.au
X-Mailer: Ximian Evolution 1.0.8-3mdk

Hi Everyone,

I run a small Linux LUG called ICE Linux users group, which we meet at
Frankston on the second Friday of each month, (this month will be 14/02)
as we are a small group with about 10 to 15 people turning up for
meetings on the night. The next club night we are looking into database
work with OpenOffice/StarOffice.I will be the one doing the
presentation, so far, I have found quite a number of documents, and URLs
to help to prepare for the club night.. now I am looking for more or
sample databases or forms that I can use to see what it can do (or to
learn myself).. if anyone can help?

O.K. this is what I have found so far..

http://homepage.ntlworld.com/garryknight/linux/oodbase.html
A great tutorial that got me started, and one that can anyone started
and interested in the hidden database treasure in OpenOffice/StarOffice.
The Next Links are to deal with connecting to SQL databases..

http://kienlein.com/pages/mysql-jdbc-howto-en.html

http://www.ooodocs.org/modules.php?name=Content&pa=showpage&pid=15

http://linuxmafia.com/faq/Apps/OpenOffice.org/mysql.html
(thanks Rick)

Some other links that are interesting for Open office as a whole, but
don't help much with the database stuff...

http://www.ooextras.org/
Now there is heaps of examples on this site but not database stuff..

So far I have managed to get the Flatdata base stuff happening, twigged
and had combo box and dropdown lists on the forms etc.. Have manged to
do a form letter(or a mail merge with the data) Next I will experiment
with mySQL with OpenOffice.

O.K. is there anyone on this list that has done anything with the
OpenOffice database, may be made a nice frontend with it's forms, or
used it's Starbasic? Know if any of the databases actually used out
there, in real life?

Cheers
Mark