Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Desktop
User Name
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.


  Search this Thread
Old 09-24-2006, 06:04 PM   #1
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Rep: Reputation: 15
Unhappy How do I connect to MySQL? or OOo base?

I have a MySQL database that I populated with data from a spread sheet. I was under the impression that I could connect to it from base. However base does not give me MySQL as a db option. It does allow a connection to MySQL using either odbc or jdbc, but I think this means I have to write my own application and I'm not at all sure I can do that, at least not as quickly as I need the data.

My question(s):
Can I in fact open MySQL databases in OOo base? If so, how?
If not, can anyone suggest a gui front end I can use? All I really need to do is update the data and create views for mailing lists.

Failing that, I can always create the views from the command line using sql, but how in the heck can I use the views with OOo mail merge?

I've tried to google for an application, but all I come up with are Windows applications and I don't have windows installed on my machine.

I was able to convert the original spread sheet to an OOo database, but it only lets me read it, I can't manipulate it. Thats why I went the MySQL route. MySQL is really over kill for my needs, so if you can help me solve this problem I won't need a front end.

Any help with either problem gratefully accepted, I'm really in a bind here.
Old 09-24-2006, 06:31 PM   #2
Registered: Sep 2005
Location: US
Distribution: Gentoo AMD64 Testing
Posts: 129

Rep: Reputation: 16
This page may be of help:

I have not used to access a MySQL database, I usually use phpMyAdmin, as I installed Apache/PHP with MySQL on my system, and phpMyAdmin is the usual way of editing MySQL databases by hand, other then using the command line.
Old 09-24-2006, 06:32 PM   #3
Senior Member
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
OO base uses an odbc to connect to mysql. Also if you check the mysql site you can find a graphical query program for mysql.
Old 09-26-2006, 08:46 AM   #4
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Original Poster
Rep: Reputation: 15
OK, my problem has been resolved, thanks to all of you for your help.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need OOo base help RetiredInMaine Linux - Desktop 8 09-26-2006 08:48 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
Scripting framework error running OOO base (v. 2.0) macros in SUSE v.10 DeekBeek Linux - Software 2 01-14-2006 01:52 PM
Help! Java Database programming using OOo Base mmarkvillanueva Programming 6 10-29-2005 01:20 AM
OOo and MySQL dnorseman Linux - Software 0 11-25-2003 05:38 PM > Forums > Linux Forums > Linux - Desktop

All times are GMT -5. The time now is 06:33 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration