James Mckenzie <[EMAIL PROTECTED]> wrote: >>From: David M >> >>I would like to use Base to connect to a MySQL database on a >>remote server (stored as part of my webhosting account). The >>client environments are WinXP. > > You need to go to the MySQL web site and get the JDBC version 3.12 > (it is definately a 3.x version) and not the 5.x testing version. > Install the file to your system in a known location. Start up > OpenOffice.org and go to tools -> options. This will open a > dialog window. Select OpenOffice.org and then Java. In this > window, click on Classpath. You need to add a new .jar file and > must navigate to the location where you stored the JDBC file. > > I am not aware of an ODBC for MySQL, but you should be able to > install it using documented procedures from Microsoft.
I didn't realise I didn't to download the connector(!): I naively assumed that it already came with Windows.. I should have realised that they only tend to provide helper software which 'helps' lock you in to their own software.. :-( I'm too used to distros where everything you need, and then some, is already in the package repositories ;-) I went to the MySQL site, and it turns out they have a connector for ODBC for download from there as well. It seemed to be slightly easier to install, so I have installed that, and now I can connect to my database successfully! Thanks for your help, David. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
