EricZander.com
 
Publications     Connecting OpenOffice.org To A Remote MySQL Database


Introduction

It is commonly said that most open source projects begin by a programmer “scratching an itch.” I am by no means a programmer but I do believe in sharing and helping others when possible.

A few months back I was planning a database solution for a running club. Their database was essentially a flat file in MS Access and I wanted to move them to a remotely hosted MySQL database. Among the many benefits would be increased accessability of the data, less of a need for regular (and often forgotten) backups and simplification of using/administering the database.

What I forsaw as the only major problem with this plan was how to allow the membership person to generate and print out renewal forms, envelopes and other printed matter as a mail merge with data from this remote database. While searching for solutions, I came across two potential solutions: Generating PDFs on the fly using various plug-ins available for PHP and I had heard that OpenOffice.org had database capabilities similar to MS Access. After further research I decided the PDF option would be too unweildy as it would require my or another technical person to make even the smallest changes to documents. I am lazy and want to give the end-users as much control as possible (and prudent). About this time I happened across an article on LinuxWorld.com which explained how to hook OpenOffice.org up to a local MySQL database on Linux.

Knowing how well OpenOffice.org works cross-platform and having had a little experience with MySQL both locally and remotely, I thought it must not be much of a leap to connect to a remote database. If this could be done, all of my running club's database problems could be solved.


page 1   2   3   4   5   Next>>

 

Other Stuff
Contact Us

 

OO.org/MySQL Tutorial
1 Introduction
2 Background
3 Tutorial
4 Summary
5 References & Links