Rick, I had to use the Other setting within CFADMIN
Using the following: JDBC URL: jdbc:mysql://localhost:3306/databasename Driver Class: com.mysql.jdbc.Driver Username: <self-explanatory> Password: <self-explanatory> -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 26, 2006 7:58 PM To: CF-Talk Subject: MySQL Connection Fails I am trying to connect to a MySQL database running on a remote linux server from CFMX7. When I setup the connection using the Microsoft ODBC utility, everything works great. When I attempt to setup the connection with the CFMX Data Sources utility, using the exact same settings, it fails with the following error: Connection verification failed for data source: cluster2 java.sql.SQLException: Communication failure during handshake. Is there a server running on syngene65.ics.uci.edu:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on syngene65.ics.uci.edu:3306? Do I need to use the CFMX data sources utility instead of the Microsoft ODBC facility, and, if so, any idea as to why this is failing would be most appreciated. Rick Colman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
