You're all good, except in the JDBC URL, you need the name of your actual database rather than the datasource name, if they're not the same. It's looking for the database name, as it doesn't know the datasource name yet.
-- Josh ----- Original Message ----- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, October 12, 2006 5:04 PM Subject: mySql connector J > 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:256608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
