OO Base to MYSQL login error
 

I am trying to connect from OO Base to an existing MYSQL Database. I get this error (see attachment)
when I try the "Test Connection" from the login page.
I'm able to access the database either from the command line or from MYSQL Query using the same id and password.
I've double checked the "jar" and "jre" all seem to work correctly.

Any help is greatly appreciated.
John

Q: Have you followed any variation of these instructions:
http://wiki.services.openoffice.org/...MySQL_and_Base

Q: Specifically, have you downloaded and verified either the ODBC or JDBC connectors for MySQL?

Q: What is the exact connection string that's failing?

Q1 - Yes, that is the site I got the instructions from.
Q2 - Yes, for the JDBC connector.
Q3 - That's the rub, all I see is that error message. Any idea where to look for the SQL that's being sent?

-- John

Hi -

This is the error in your screenshot:
It sounds like it might be a language configuration issue.

Please try this (assuming that UTF8 is what you want):
As far as SQL tracing, try setting "profileSQL=true" in your JDBC connection properties:
http://dev.mysql.com/doc/refman/5.0/...roperties.html

'Hope that helps

Paul --

Thanks, the utf8 lines fixed the problem.

-- John