Your config is correct and is the same as mine. Did you restart CF after installing the MySQL driver? I assume it's already been installed in the WEB-INF/lib/ directory.
Jon On Oct 12, 2006, at 8:04 PM, Doug Brown wrote: > Can someone tell me what they have listed in CF for the mySql > connector? > > Here is what I have > > CF DataSource = myDsn > JDBC URL = jdbc:mysql://localhost:3306/myDsn > Driver Class = com.mysql.jdbc.Driver > Driver Name = blank > Username = ROOT > Password = ******* > > I get the following error > > Connection verification failed for data source: XXXX > java.sql.SQLException: No suitable driver available for XXXX, > please check the driver setting in resources file, error: null > The root cause was that: java.sql.SQLException: No suitable driver > available for nexbid, please check the driver setting in resources > file, error: null ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
