Advanced

Connect OpenOffice.org to MySQL

Posted by Scott_Ruecker on · 8 comments
Linux.com; By Dmitri Popov
Mail this story
Print this story

One of the good things about OpenOffice.org is its ability to use different database engines. Just give it the right driver, and OpenOffice.org can connect to virtually any database system, including MySQL. However, deciding what database driver to use and configuring a connection between MySQL and OpenOffice.org can be a bit tricky. Let's walk through the process.

Full Story

  Nav
» Read more about: Story Type: News Story; Groups: MySQL, OpenOffice.org

» Get new stories by e-mail: nightly or as they are published

« Return to the newswire homepage

  Related stories
» More like this

Comments (8)

We need to eliminate the meme that MySQL is easier than PostgreSQL to manage. It's not when you use a great tool like pgAdmin III: http://www.pgadmin.org/

pgAdmin III is available from the Fedora and Ubuntu repositories. I don't know about the base Debian repositories, but there are instructions on adding the appropriate line to the sources.list for apt.

There are ODBC and JDBC connectors available for PostgreSQL. I even wrote up a short instruction for connecting OOo to PostgreSQL using JDBC over in the OpenOffice.org forums: http://www.oooforum.org/forum/viewtopic.phtml?p=120400



I don't know that censorship is the answer here. eliminating the memes and all. Maybe work on the areas where postgresql suffers in comparison to mysql. Soar with your strengths, manage your weaknesses, you know....
Indeed, pgAdmin III appears quite impressive. I have to give PostgreSQL another try.
@herzeleid

Perhaps I should have phrased it: "... overcome the meme ...".

Censorship certainly is not the answer in this. But producing laudatory articles about PostgreSQL comparable to the articles on MySQL would be.
I know, I'm just playing devil's advocate here...
I would just like to see more documentation for using PostgreSQL with apps like OOo and others. There was an effort to enable GnuCash to work with PG as a back-end, but it died apparently. :-( Things like that, though would go a long way toward helping more people discover how much fun PG can be. In my limited experience with it, I really quite like it. But I haven't gotten into anything fancy yet.
Quoting:I don't know about the base Debian repositories, but there are instructions on adding the appropriate line to the sources.list for apt.


This, maybe? http://packages.debian.org/unstable/misc/pgadmin3
http://dba.openoffice.org/drivers/postgresql/

At least on my system, the install was easy.

Post a comment

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post