Error connecting to MySQL with ODBC

[webagent0011]

I am trying to connect to an intranet MySQL 5 DB server using MySQL 3.51 drivers. I am using an ODBC system DSN that is on my system to support our company's primary software. When I test the connection in Base I receive the following error.

[MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client

I really want to use base so I can to get to creating the reports that I want rather than messing around trying to set up some other way to do it.

Thanks in advance,
Stephen

[hol.sten]

When I test the connection in Base I receive the following error.

[MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client

I really want to use base so I can to get to creating the reports that I want rather than messing around trying to set up some other way to do it.

If you cannot connect with the ODBC driver, why don't you give the MySQL JDBC driver a try? For more on this, try these links:
http://user.services.openoffice.org/en/ ... MySQL+JDBC
http://user.services.openoffice.org/en/ ... mysql+jdbc

[webagent0011]

Is there any problem connecting to a database using JDBC when there are other connections via ODBC? Thanks.

Stephen

[hol.sten]

Is there any problem connecting to a database using JDBC when there are other connections via ODBC?

I don't think so. I think it does not matter to the database whether you use JDBC, ODBC or both at the same time.