[aclug-L] FW: Use OpenOffice to Access Databases

["Dale W Hodge" <dwh@xxxxxxxxxxxxxxxx>]

-----Original Message-----
From: Linux_Desktop_Apps@xxxxxxxxxxxxxxx
[mailto:Linux_Desktop_Apps@xxxxxxxxxxxxxxx] 
Sent: Thursday, September 05, 2002 1:09 AM


LINUX DESKTOP APPLICATIONS --- September 05, 2002
Published by ITworld.com -- changing the way you view IT
http://www.itworld.com/newsletters
_________________________________________________________________

HIGHLIGHTS

* Access' limitations should not be the main reason for finding an 
  alternative database as ease-of-use and security form a much more 
  compelling impetus to change. 
_________________________________________________________________

Use OpenOffice to Access Databases
By Eric Foster-Johnson

After writing a column searching for Linux alternatives to Microsoft's
low-end database, Access, I received some great replies. Many readers
pointed out the limitations of Microsoft Access, and while all of them
are true, such comments miss the point.

Users clearly want low-end databases that are relatively easy to use and
a relatively easy path to make data-entry forms and other simple
database-based applications. The two main databases that come with most
Linux distributions, PostgreSQL and MySQL, far exceed Access as safe
repositories for your data. Both these databases offer many more
database features than Access, except for the handy means to make
data-entry forms and simple database-driven applications.

A number of readers pointed me to StarOffice and the latest
OpenOffice.org software. (StarOffice is a commercial product from Sun
while OpenOffice.org is an open-source version that acts as a base for
StarOffice.) This proved to be the best suggestions so far. 

OpenOffice.org (http://www.openoffice.org) provides a near drop-in
replacement for Microsoft Office. The software runs on Linux, Windows,
and a number of Linux versions. A MacOS X port is also in the works. 

The OpenOffice.org database access sub-project
(http://dba.openoffice.org) includes modules in the core office suite to
access databases using a variety of methods including ODBC (mostly
Windows), JDBC (Java), ADO, along with dBase and CSV, or Comma-Separated
Value, files. You can create forms on top of data from a database, along
with performing limited database functions within the OpenOffice.org
suite.

A few how-to documents appear at http://dba.openoffice.org/howto. The
most useful one for Linux users is the document on how to connect to the
MySQL database using a Java JDBC driver at
http://dba.openoffice.org/howto/mysql_jdbc.html.

OpenOffice.org connects to databases by defining data sources within the
suite. A data source tells OpenOffice.org how to connect to a particular
database. The OpenOffice.org site describes how to set up a data source
at http://documentation.openoffice.org/HOW_TO/data_source/data1_EN.html.
This example shows how to connect to a data source, create a table in
the database, and enter data.

You can use dBase or CSV files if you just want to edit data locally.
Many users, though, will opt for using a real database rather than just
files. You can access most databases from the suite via the Java JDBC
database drivers. (JDBC stands for Java DataBase Connectivity.) Just
about every database in existence supports JDBC access. A good listing
of where to find JDBC drivers appears at
http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm.

If you cannot get a JDBC driver, you can set up ODBC, Open DataBase
Connectivity. Most ODBC usage is on Windows, but you can use the
unixODBC project code, from http://www.unixodbc.org/, to use ODBC on
Linux.

About the author(s)
-------------------
Eric Foster-Johnson has written 14 books on Linux, Unix, programming 
and open source tools. Eric can be reached at 
Eric.FosterJohnson@xxxxxxxxxxx or at http://www.pconline.com/~erc.
__________________________________________________________________

ITWORLD.COM NEWSLETTER ARCHIVE

Index of Linux Desktop Applications
http://itw.itworld.com/GoNow/a14724a63912a76028222a3

Help Me Please, El Kaptain
http://itw.itworld.com/GoNow/a14724a63912a76028222a1

It's All About Choice
http://itw.itworld.com/GoNow/a14724a63912a76028222a2
__________________________________________________________________

CUSTOMER SERVICE

SUBSCRIBE/UNSUBSCRIBE:
- Go to: http://www.itworld.com/newsletters
- Click on "View my newsletters" to log in and manage your account
- To subscribe, check the box next to the newsletter
- To unsubscribe, uncheck the box next to the newsletter 
- When finished, click submit

Questions? Please e-mail customer service at: mailto:support@xxxxxxxxxxx
___________________________________________________________________

CONTACTS

* Editorial: Andrew Santosusso, Newsletter Editor, 
  andrew_santosusso@xxxxxxxxxxx
* Advertising: Clare O'Brien, Vice President of Sales, 
  clare_obrien@xxxxxxxxxxx
* Career Corner: Janis Crowley, Vice President/General Manager, IDG 
  Recruitment Solutions, janis_crowley@xxxxxxxxxxxxx
* Other inquiries: Jodie Naze, Senior Product Marketing Manager, 
  jodie_naze@xxxxxxxxxxx

____________________________________________________________________

PRIVACY POLICY

ITworld.com has been TRUSTe certified 
http://www.itworld.com/Privacy/

Copyright 2002 ITworld.com, Inc., All Rights Reserved.
http://www.itworld.com


-- This is the discussion@xxxxxxxxx list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi