I have just upgraded an existing database (installed on CF MX 6.1 and MySQL
4.1) to the latest build of MySQL 5.

I attempted connecting via a JDBC Connector/J and although this connected it
started throwing all sorts of nasty query errors so have abandoned that and
attempted to go back to an ODBC method. I have installed the latest MySQL ODBC
driver, stopped and restarted MySQL and CF and have confirmed the db is working
fine by connecting via a MySQL gui. When I attempt to add a DSN via CF Admin
using correct port, servername, username, password it fails with the error
below.

If I do have to resort to a JDBC connection, please can someone give me some
guidance on why queries containing both JOINS and WHERE clauses would cause
them to error.

thanks!


Connection verification failed for data source: XXXXXXXX_mysql
[]java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3308?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on localhost:3308?