>From: David M <[EMAIL PROTECTED]> >Sent: Oct 6, 2006 7:59 AM >To: [email protected] >Subject: [users] Base/2.0.3: Connecting to MySQL DB on remote server >from WinXP? > > >Hi, > >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. > >I have tried to read up on Base documentation, and although I have >some idea of the direction in which to proceed, I don't understand >it all. > > >I gather I need to set up an ODBC or JDBC connection to my remote >database. > 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. James McKenzie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
