On Sunday 10 December 2006 19:57, Thomas Ronayne wrote: > I've trying to, using the data base wizard, set up a MySQL connection. > > I have, apparently, successfully set up the JDBC connection (Test class > reports that the JDBC driver was loaded successfully). > > I'm trying to connect to a data base named "sakila" on "localhost" port > "3306 using driver class "com.mysql.jdbc.Driver." This is the test data > base from Roland Bouman's blog about connecting MySQL to OpenOffice. I > can connect to that data base with "mysql --user=username > --password=password sakila" and can waltz around looking at tables and > everything that I expect to be able to do in MySQL. > > I have tried every combination I can think of for Server URL; localhost, > mysql://localhost, http://localhost, 127.0.0.1, etc., etc. and cannot > get connected to that or any other data base. Using, say, > mysql://localhost the error is "must specify port after ':' in > connection string. Using localhost (or the address of the machine on the > local network) the error is "communications link failure due to > underlying exception:" and the rest of the error message is obscured by > and OK button that does nothing but may be ** BEGIN NESTED EXCEPTION ** > java:net.socketException. > > Java is Java(TM) 2 Runtime Environment, Standard Edition (build > 1.5.0_09-b01), the JDBC driver is mysql-connector-java-5.0.4-bin.jar.. > > Am I missing something in /etc/my.cnf, maybe? Something else? The > "stock" bibliography data base is installed -- do I need to blow it away?
Hi Thomas, If you still have this problem [email protected] may be able to help you. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
