I would research JConnector from mysql.org. It is a JDBC driver for MySQL datasources.
Here is the isntruction from Adobe: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253 Teddy On 9/14/06, Patrick McDonough <[EMAIL PROTECTED]> wrote: > > 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:253153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
