Marc, Thanks for the information. I'm working with OOo 2.0 RC2 and found that a classpath must be added at the tab java. I did that and it ordered me to give the directory where to find it. Tha's what I did. Then I went to File -> Wizards -> Address Datasource -> other -> MySQL (JDBC) -> database name (test) -> username -> test connection. The next window told me that " Due to an unexpected error OOo crashed". Now I did read in the manual that you had to use the "mm.mysql-2.0.4-bin.jar" driver. However I have installed the latest from the MySQL-site and the driver is mysql-connector-3.1.1-bin.jar (a completely different driver?). However, I have obtained the mm.mysql-2.0.4 driver from sourceforge (it is old, from 20000 and installed the path but no result. In the java-tab I can see that I have installed "Free Software Foundation Inc" java runtime system version 1.4.2 and it is located in /usr. Well, I have a directory /usr/j2r1.4.2and a directory /usr/java/jre1.5.0_04. I am rather confused by j2r1.4 and jre1.5 as in any mails one is talking about "java 1.4 and ", java 1.5" which latter actually is named "java 5.0". Again, I have a limited knowledge of java, dating from the first version's of Sun (I thought 1.0) back in the nineties and then only superficially (for what I needed). Maybe you can shed some light on this tangle. Joep
On Sun, 2005-10-16 at 06:58 +0200, Marc Santhoff wrote: > Am Samstag, den 15.10.2005, 17:58 +0200 schrieb J.L. Blom: > > Steve, > > I have been tinkering with the mysql JDBC but till now no luck. > > I followed the install documentation but got stuck where I have to add > > the location of the JDBC-file to the CLASSPATH. I'm working with bash > > (not csh) so setenv doesn't work. Moreover, I assume that the CLASSPATH > > must be set in the java environment and I have no experience with it. > > I tried " export CLASSPATH=/path/to/JDMBCetc.jar" but that didn't work. > > I even have started a csh session to set CLASSPATH with setenv but > > that also didn't work (presumably because OOo uses the bash > > environment). > > The classpath has to be set in OO.o and it must be completely > (quickstarter) restartet afterwards. > > You can find this setting in the menu "Tools - Options" and then > selecting "OpenOffice.org - Security" (for 1.x, 2.0 should be similar). > There is a button "Browse..." at the input field for the classpath, hit > it and add the missing path in the following dialog. > > Btw., I think mixing 32 bit and 64 bit apps and libs will not work, get > both animals from the same zoo and it'll work. > > HTH, > Marc > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
