I have a problem with datasource connections in CF admin to our existing MySQL(MySql 4.1.2) databases on our datbase server (on a LAN). The application server running Coldfusion is a "Virtual" server.
Note: Tried all below with MS Firewall turned off with the same results. When using the MySQL3.x driver I get the following error: Connection verification failed for data source: swofficesystems.com java.sql.SQLException: Communication failure during handshake. Is there a server running on 10.2.2.48:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on 10.2.2.48:3306? Whene using the Com.mysql.jdbc.Driver Connection verification failed for data source: southwestofficesystems.com java.sql.SQLException: No suitable driver available for southwestofficesystems.com, please check the driver setting in resources file, error: null The root cause was that: java.sql.SQLException: No suitable driver available for southwestofficesystems.com, please check the driver setting in resources file, error: null So I installed MySQL 5 on the same (new Virtual) server (to rule out network issues) thats running Coldfusion and tested again with both drives MySql 3.x: Connection verification failed for data source: swofficesystems.com java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? com.mysql.jdbc.Driver Connection verification failed for data source: swofficesystems.com java.sql.SQLException: No suitable driver available for swofficesystems.com, please check the driver setting in resources file, error: null The root cause was that: java.sql.SQLException: No suitable driver available for swofficesystems.com, please check the driver setting in resources file, error: null Any ideas - must resolve HELP Pat McDonough ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
