[KLUG Members] Data Access Presentation Posted

[Adam Williams]

The Data Access Revisited presentation has been posted -
ftp://ftp.kalamazoolinux.org/pub/pdf/DataAccess-2003.pdf (~2Mb)

The old (original) Data Access presentation is still available -
ftp://ftp.kalamazoolinux.org/pub/pdf/dbaccess.pdf
*This presentation includes information on GDA (the GNOME data access
architecture), but much of that information is now obselete.  We intend
to produce a GDA specific presentation in the future when GDA stabilizes
a bit.

Various data access RPMs for RH9 are available at -
ftp://ftp.kalamazoolinux.org/pub/projects/awilliam/misc-gnome/rh9
*This includes recent GDA, MDBtools, and unixODBC builds.

The "Advanced Relational Database Concepts" presentation from 2002 is
still available at - ftp://ftp.kalamazoolinux.org/pub/pdf/rdbms.pdf
* This presentation covers concepts like primary keys, foriegn keys,
constraints, triggers, and stored procedures.  Examples are for
PostgreSQL.

Links -
The OpenOffice Data Access Project - http://dba.openoffice.org/
The OpenOffice SDK -
http://www.openoffice.org/dev_docs/source/sdk/index.html
OpenOffice Document Indexer (good Java integration example) -
http://www.jerger.org/en/indexer.html
unixODBC Site - http://www.unixodbc.org/
ODBC Programmer's Library for C++ -
http://otl.sourceforge.net/home.htm
unixODBC & FreeTDS (M$-SQL & Sybase) -
http://www.unixodbc.org/doc/FreeTDS.html
OO, unixODBC, & MySQL tutorial -
http://www.unixodbc.org/doc/OOoMySQL9.pdf
The OpenOffice forums -
http://www.oooforum.org/
An example OpenOffice Basic scalc macro -
http://www.fenk.wau.nl/~oever/software/openoffice/index.html
StarOffice programming tutorial -
http://api.openoffice.org/basic/man/tutorial/tutorial.pdf
OpenOffice Address Books and Form Letters -
http://www.linuxjournal.com/article.php?sid=6269
Ximian OpenOffice.org pages -
http://ooo.ximian.com/
Creating flat file databases with OpenOffice -
http://homepage.ntlworld.com/garryknight/linux/oodbase.html
 *included information on forms