Oh, one other note. Some of the newer connector J drivers are known not to work with CF. The 3.1 drivers are compatible. The one I'm running is:
mysql-connector-java-3.1.10-bin.jar Jon On Oct 12, 2006, at 8:13 PM, Jon Clausen wrote: > 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:256610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
