I use to have the same problems. You have to use one of the later versions of the mySQL ODBC connectors Such as 3.0.
Then create the ODBC in CFADMIN using Other and the following parameters: jdbc:mysql://localhost:3306/databasename com.mysql.jdbc.Driver Well atleast that works for me. -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 10:01 PM To: CF-Talk Subject: CF and MYSQL 5 XP Pro/CFMX7/mySQL5 I haven't messed with mySQL lately, but I need to start using it again. I noticed the mySQL DSN's no longer worked on my dev machine. Whenever I try using the JDBC driver, I get an error: ******************************************************* Connection verification failed for data source: test2 java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3307? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3307? ******************************************************* I'm positive my settings are correct and the db server is running. After googling the error, I came across a technote dealing with this issue, followed the directions line by line ..... still no joy! Same error! The only way I can make a mySQL dsn work is to 1. Create the dsn thru windows adminstrative tools. 2. Create the dsn in CF admin via ODBC, pointing it to the one I created in windows. This tests successful, but I'm irritated I can't make it work thru JDBC. What am I missing here? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
