Has anyone got Open Office to access a remote mysql database?

[Chris G]

On Wed, Dec 09, 2009 at 05:36:37PM -0800, NoOp wrote:
> On 12/09/2009 02:25 AM, Chris G wrote:
> > On Tue, Dec 08, 2009 at 11:44:41AM -0800, NoOp wrote:
> ...
> >> However, also note:
> >> <http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0/Known_Issues>
> >> But if the server is on your LAN then this shouldn't be a problem.
> >> 
> > Yes, I don't think this is a problem for me.  It may well also be that
> > having got it to work with the above connector the information I have
> > gleaned will enable me to get the JDBC connector to work as well which
> > will also work 'beyond the LAN'.
> > 
> 
> Then this might be of help:
> http://wiki.services.openoffice.org/wiki/Connect_MySQL_and_Base
> 
Yes, it at least clarifies the confusing "Server URL" field somewhat,
and it points out that you need to open up the mySql server so that
remote connections are allowed (although it does that wrong for ubuntu
9.10, it's a little out of date).  It's also a little light on getting
the Java CLASSPATH set up correctly for the connector.

All in all it's a bit of a can of worms though it *does* all work when
you get everything right.


-- 
Chris Green