On Tue, Mar 11, 2008 at 10:33:37AM -0400, Therese Trudeau enlightened us:
Sounds like an OOo problem, then. When I briefly tried testing it, there was a couple of driver options to connect to MySQL, you might try using the one you're not (IIRC one was ODBC and the other was JDBC).
Ah HA! That might be the problem, I'm using the JDBC driver and I don't have the ODBC driver installed. Do you know where i could download the ODBC driver?
Or, is the ODBC driver the same as the sql-connector-java-5.0.8 driver? That one I do have; I set up OpenOffice to point to that one too as I did for the JDBC Driver.
In a phrase: I have no idea :-)
It was just something I noticed when messing around with it. I've never actually had a need to hook OOo to a database. Asking on a OOo list/forum might be more fruitful.
Matt