OpenOffice Base And MySQL - HOWTO

Posted by natas on Nov 18, 2005 2:33 PM EDT; By Theoden
Mail this story
Print this story

Do you have an existing MySQL database with valuable data in it? Would you like to be able to access it with 2.0's new Base database application?

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 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 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 is complete with screenshots and more! Click here for the article.

Full Story

» Read more about: Story Type: Tutorial; Groups: Community

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.