LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices

Reply
 
Search this Thread
Old 09-24-2006, 06:04 PM   #1
RetiredInMaine
Member
 
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 OpenOffice.org 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
chadl
Member
 
Registered: Sep 2005
Location: US
Distribution: Gentoo AMD64 Testing
Posts: 129

Rep: Reputation: 16
This page may be of help: http://dba.openoffice.org/FAQ/specif...l#connectmysql

I have not used OpenOffice.org 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
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,043

Rep: Reputation: 83
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
RetiredInMaine
Member
 
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.
 
  


Reply


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


All times are GMT -5. The time now is 07:02 AM.

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