Connecting to MySQL using Open Office Base via ODBC...

[Gabriel Dragffy]

On Tue, 2007-05-29 at 14:06 -0700, NoOp wrote:
> My guess is that the Ubuntu (U)OOo wizards are screwed up (see:
> <https://bugs.launchpad.net/ubuntu/+source/openoffice.org/?field.searchtext=&orderby=-datecreated&search=Search&field.status%3Alist=Unconfirmed&field.status%3Alist=Confirmed&field.status%3Alist=In+Progress&field.status%3Alist=Needs+Info&field.status%3Alist=Fix+Committed&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=>)
> That said; I decided to test using a local, know working database that I
> have on my system. The database was a converted ACT (old Windows contact
> manager) dBase file that I converted to an OOo have use on a regular
> basis. Here is what I tested, using the exact same local odb:
> 
> 1. In OOo 2.2 official - (O)OOo base I open the tables, create queries,
> forms, reports with no problem. Everything works.
> 
> Ditto for StarOffice8 (w/Update 6).
> 
> 2. In (Ubuntu)OOo 2.2:
> 	- I can open the tables
> 	- Use Wizard to creat query does nothing
> 	- Create Query in Design View opens & works
> 	- Forms wizard does not work
> 	- Create Form in Design View works
> 	- Reports wizard does not work - in only brings up a start form
> 
> Note: Java JRE is Sun 1.6.0_01. I can also test w/1.6.0 and 1.5.0_07.
> 
> So as to ensure that there was no common use of (U)OOo and (O)OOo files
> I tested (U)OOo and StarOffice8 on one machine, and the (O)OOo and
> StarOffice8 on a different machine - same database.
> 
> So, before you throw in a MySql connection to complicate matters even
> more, I'd test a local simple local database first. Then after you
> verify the above, unload (U)OOo 2.2 and install (O)OOo 2.2 directly from
> http://openoffice.org. Note: make sure you download the non JRE version
> & then load your own JRE from Sun directly.
> 
> Gary
> 
> 
> 

Hi

I have since downloaded and install the Java MySQL connector, I tried
using JDBC instead of ODBC. It worked a little better, in that I didn't
get errors. However, I suffered the same probs as you (above), where
certain wizards wouldn't work.


-- 
Gabriel Dragffy FdA BA(Hons)


Websites by Gabe:
http://dragffy.com
http://andrew-norman.com

On-line CV:
http://dragffy.com/gabescv