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

[NoOp]

On 12/10/2009 01:22 AM, Chris G wrote:
> 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.
> 
> 

Best place for further answers is on the OOo Base list:
http://dba.openoffice.org/
  http://dba.openoffice.org/servlets/ProjectMailingListList
    users @ dba.openoffice.org
Or the forums:
http://support.openoffice.org/index.html
  http://user.services.openoffice.org/en/forum/

Be _sure_ to specify that you are using Ubuntu OOo instead of standard
OOo if that is the case. You can also use launchpad answers:
<https://answers.launchpad.net/ubuntu/karmic/+source/openoffice.org/+gethelp>

https://answers.launchpad.net/ubuntu/karmic/+source/openoffice.org/+questions