OpenOffice Base And MySQL - HOWTO

Well, it's not that hard to do, and Base is a great program. With it you can (1) create new tables for your data and/or change them as your needs change; (2) maintain indexes on your database tables to make data access faster and easier; (3) view the tables in an editing grid and add, change, and delete records; (4) use the Report Wizard to produce impressive reports from your data; and (5) use the Form Wizard to create 'instant' database applications.

In addition to all that, you can also perform simple (single column) or complex (multi-column) sorts; (1) view subsets of your data with simple (one-click) or complex (logical query) filters; (2) create powerful queries to show your data in new ways, including summaries and multi-table views; (3) produce reports in a wide variety of formats using the Report AutoPilot. You can read more here.

So, you already have your MySQL database running. How do you get Base to connect to it so you can do all these wonderful things? Well - I will assume you have OpenOffice.org 2.0 installed on your system. If not, do so first using whatever package management system/method you prefer for your linux distro. Once you have OpenOffice.org 2.0 installed and running, you will need to install an ODBC connector so that Base can use it to connect to you MySQL database. You will want to install 'myodbc' on your system.

Full Article on Linuxgangster.org is complete with screenshots and more! Click here for the article.

Full Story