Database/Drivers/MySQL Native
From Apache OpenOffice Wiki
This page is dedicated to the MySQL native driver, which is currently being developed by MySQL and OpenOffice.org engineers.
Known issues
- Existing table fields cannot be altered
The implementation simply didn't get that far ... for the final release, we expect this to be fixed - The user interface is not remotely intuitive
That's true. The final version will run in OpenOffice.org 3.0 only, which will have a dedicated UI. - The driver doesn't run in OpenOffice.org 3.0 developer snapshots
Well, it's not intended to do. Please use it with the 2.4 release only, everything else is not supported right now, and may lead to all kind of unwanted results. - sub forms do not work
Well, not all of them don't ... more precise, in general SQL statements with named parameters (":param_name") do not work. The ODBC/JDBC driver wrapper used to replace them with unnamed parameters ("?"), since MySQL does not understand them, but the native driver does not do this, yet. Since sub forms usually make heavy use of such named parameters, they currently fail. - specifying a different socket path is not supported
This will be fixed wiith new UI (3.0). As a workaroud you can specify a port number. In this case the driver will establish a connection via TCP, e.g. 127.0.0.1:3306/yourdb.