-----Original Message----- >From: >Sent: Oct 16, 2006 1:47 PM >To: [email protected] >Subject: [users] Using base with mysql > >I understand that Base can be used with Mysql. I actually need just >that- but the mysql database is not local. It is on a server that I >have ssh access to. How can I connect that database with Base? Thanks >in advance.
Please go to the MySQL web site and download version 5.0.3 of the Java Database Connector. Install this into a known location. Start up OpenOffice.org and click on Tool -> Options. Select OpenOffice.org and then Java. OpenOffice.org will check your system for installed Java Runtime Engine products. Once the check finishes, click on the Add button and then File. Navigate to where you placed the JDBC .jar file and select it. Close the dialog box when the process finishes. Go to Base and create a new database. Select existing database and then MySQL JDBC. You will have to fill in the location of the file(s). You should be able to log into the database using your SSH credentials. If you are not able to do this, please ask for further assistance on the DBA development list ([email protected]). Subscription to this list is mandatory and is done by sending an empty message to [EMAIL PROTECTED] James McKenzie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
