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?

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.

I found the site I used. jdbc looked easier than unixodbc. Check it out.

http://dba.openoffice.org/FAQ/specif...l#connectmysql

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?

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

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.

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.