To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66123
------- Additional comments from [EMAIL PROTECTED] Mon Aug 7 15:03:44 -0700 2006 ------- @james : not any tricks that I can think of :-( The driver should be installed somewhere where Java and OOo can see it, and read it. I did this by copying the jar file to /Library/Java/Extensions (this is the place where Java extension libraries are classically stored), but you could always try your home directory. You need to tell OOo about the classpath, so in OOo you need to go to the Options - Java menu entry, wait for it to find your Java installation (which can take some time), and then click on the classpath button (third button down on the right of the dialog), click on add, and then navigate to the directory where you have put the driver and then select it and press OK. After that, you need to restart OOo (you may get a message telling you this, but it doesn't always display for some reason). Upon restart of OOo : I just used the db wizard to create a new mysql database document that chose the JDBC driver. This choice is actually suggested by the OOo database creation wizard. You get the opportunity to test the default provided driver class, which worked on my setup, and then on the next step you get to enter the parameters for accessing the mysql db. Since you have installed mysql locally, you should enter 127.0.0.1 or localhost as the name of the server, and then the name of the mysql db, which I assume in your case is test (you might have to try with Test, I'm not sure). Leave the default port of 3306 as it is. When you have filled these in, you can test the connection from that same dialog. Again, this should work. >From memory, the test mysql db does not require a user password to be set, but that might have changed recently, I don't know, I always grant myself rights as a user on the mysql db to do the stuff that I need to do beforehand and then create my db and tables as I wish, so I hardly ever use the test db provided. alex --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- 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]
