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

[Chris G]

On Tue, Dec 08, 2009 at 11:44:41AM -0800, NoOp wrote:
> On 12/08/2009 11:01 AM, Chris G wrote:
> > I am trying to set up Open Office's database access to connect to a
> > remote (as in another computer on my LAN) database.  I'm failing
> > pretty miserably. This is in [x]ubuntu 9.10, Open Office 3.1.1.
> > 
> ...
> 
> You might want to give this a try:
> http://extensions.services.openoffice.org/project/mysql_connector
> further ref/info:
> <http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0>
> 
Excellent, thank you.  It hasn't *immediately* fixed my problem but
the description of how to use it has clarified most of the items I
mentioned above where the Open Office help system is worse than
useless.   Also the error message I got from the above connector
actually told me what the mysqld error was, unlike the JDBC connector. 

Thanks again!


> 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'.

-- 
Chris Green