LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Mandriva
User Name
Password
Mandriva This Forum is for the discussion of Mandriva (Mandrake) Linux.

Notices

Reply
 
Search this Thread
Old 11-24-2003, 10:01 AM   #1
pete_bogg
Member
 
Registered: Aug 2003
Location: Kentucky
Distribution: Ubuntu 9.10
Posts: 153

Rep: Reputation: 30
MDK9.2 - MySQL with OpenOffice Frontend


Has anyone got the OpenOffice database frontend to work with MySQL?

I've tried a couple of times and still cannot get it to work. I think my problem is with the ODBC drivers (unixODBC and myODBC) and setting up the ini files.

I have read the "OpenOffice.org 1.0, ODBC, and MySQL 'How-to'" by John McCreesh, and the "Making MySQl, ODBC & OpenOffice 1.0 work together, Part 1 & Part 2" by Joe Barr. I still cannot get it to work.

Any ideas?
 
Old 11-24-2003, 10:29 AM   #2
dnorseman
Member
 
Registered: Aug 2003
Location: Chicago, USA
Distribution: RHEL, CentOS, Ubuntu
Posts: 43

Rep: Reputation: 15
I just got it working last night, I can connect to mysql via data sources but cannont yet edit or add new records. I am on mdk9.2, downloaded j2sdk-1_4_2 and mysql-connector-java-3.0.9-stable. Install both. Open openoffice and goto tools/options and select securtiy. You have to add the class path to where your mysql-connector was placed. From there all I did was start mysql and opened data sources with the following:

General tab
name: XXXXX
dbtype JDBC
data source URL: jdbc:mysql://hostname:3306/dbname

jdbc tab
jdbc driver class: com.mysql.jdbc.Driver
enter user name

I could then access my mysql data.

So far thats all I have done. I am trying to move from microsoft access into ooo/mysql. It looks very promising. I will try to find the sites where I found most of this info and post them. I think it was from dba.openoffice.org/ and mysql sites. I am still working on the edit/add issue but I think it has to do with priviliges.

Hope that helps.
 
Old 11-24-2003, 10:36 AM   #3
dnorseman
Member
 
Registered: Aug 2003
Location: Chicago, USA
Distribution: RHEL, CentOS, Ubuntu
Posts: 43

Rep: Reputation: 15
I found the site I used. jdbc looked easier than unixodbc. Check it out.

http://dba.openoffice.org/FAQ/specif...l#connectmysql
 
Old 12-02-2003, 10:47 PM   #4
pete_bogg
Member
 
Registered: Aug 2003
Location: Kentucky
Distribution: Ubuntu 9.10
Posts: 153

Original Poster
Rep: Reputation: 30
dnorseman,

A couple of questions:

For the class path, I used "/usr/local/src/mysql-connector-java-3.0.9-stable/"
Do I need to include "mysql-connector-java-3.0.9-stable-bin.jar" to this path statement?

For the datasource URL, I used "jdbc:mysql://localhost:3306/dbname"
The database "dbname" does not exist. Do I need to create a database first?

OOo asked if it should set up the driver, I did go through the window to do so.

When trying to go to the tables tab, I get the following error:

No connection could be established for the URL
jdbc:mysql://localhost:3306/dbname

Please check the current settings, for example: user name and
password.

Could this be because the database "dbname" does not exist?
 
Old 12-03-2003, 12:17 AM   #5
dnorseman
Member
 
Registered: Aug 2003
Location: Chicago, USA
Distribution: RHEL, CentOS, Ubuntu
Posts: 43

Rep: Reputation: 15
I did create a database via command line and then connected to it via Ooo. Unfortunately, my laptop is at work so I cannot check the path. Try to create the database then go from there as well as create mysql users. I will post more about the path tomorow from work.

Good Luck
 
Old 12-03-2003, 12:20 AM   #6
PDR60
Member
 
Registered: Aug 2003
Location: Oakland, TN
Distribution: Debian, Kubuntu
Posts: 257

Rep: Reputation: 30
Why not just use the MySQL command center. I use all the time. You can control every aspect of MySQL with it. It looks allot like the MSSql enterprise manager.
 
Old 12-04-2003, 07:11 AM   #7
pete_bogg
Member
 
Registered: Aug 2003
Location: Kentucky
Distribution: Ubuntu 9.10
Posts: 153

Original Poster
Rep: Reputation: 30
dnorseman,

I changed "dbname" to "test" (an autocreated mysql database) and everything worked OK.

I was somewhat suprised that OOo data sources did not allow me to import a .csv file or a spreadsheet file into a table.

Oh well, only 30 some records, copy-paste, copy-paste, copy-paste........

All said and done, I'm a happy camper.

Last edited by pete_bogg; 12-04-2003 at 07:12 AM.
 
  


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
Cross-Platform GUI Frontend for MySQL chandru.in Linux - Software 2 08-10-2005 07:13 AM
OpenOffice Base & MySQL datadriven Slackware 3 06-22-2005 06:37 PM
Openoffice Base 2 beta. How to use MySQL KR-data Linux - Software 1 04-24-2005 12:45 PM
Slackware + OpenOffice + MySQL mikz Slackware 0 09-07-2004 03:54 PM
ODBC/MySQL/OpenOffice linuxfond Linux - Newbie 1 05-09-2004 04:27 PM


All times are GMT -5. The time now is 09:29 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