Just to confirm, are you using the "other" selection when specifying the driver type in CF Admin? You can't use the MySQL 3.x type, you have to choose "other." Then when filling out the datasource info you have to specify:
JDBC url: jdbc:mysql://localhost:3306/yourdatabasenamehere Driver class: com.mysql.jdbc.Driver If you've done all that and it still doesn't work, not sure where to go. -- Josh ----- Original Message ----- From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, April 10, 2006 10:21 AM Subject: Re: MySQL Connector/J problems > Nope. Removed the 3.1 jar file and added the 3.0.17 jar file. Restarted > the > service, still no joy. > > On 4/10/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: >> >> AFAIK JDBC connector >=3.1 doesn't work right with CFMX7. 3.0 does seem >> to >> work reliably, I'm currently using 3.0.17 with no problems. Others may >> have >> better info. >> >> -- Josh >> >> >> ----- Original Message ----- >> From: "Deanna Schneider" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[email protected]> >> Sent: Monday, April 10, 2006 10:02 AM >> Subject: MySQL Connector/J problems >> >> >> > Hey folks, >> > I'm trying to install a demo version of abelcommerce, and to do it I >> > needed >> > to install the connector/j JDBC connector. The Adobe docs say to use >> > version >> > 3.1.10, but the ablecommerce site says to use 3.1.7. I went with the >> > ablecommerce recommendation, since I need to specifically test it. >> > >> > Anyway, I can't get the datasource to verify. I get this error: >> > >> > Connection verification failed for data source: ablecommerce >> > java.sql.SQLException: No suitable driver available for ablecommerce, >> > please >> > check the driver setting in resources file, error: null >> > The root cause was that: java.sql.SQLException: No suitable driver >> > available >> > for ablecommerce, please check the driver setting in resources file, >> > error: >> > null >> > >> > I've followed all the directions in the Adobe technote here: >> > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170 >> > >> > And, I've verified that there are >> > 1. no trailing spaces >> > 2. the driver.class file exists at >> > C:\CFusionMX7\wwwroot\WEB-INF\lib\com\mysql\jdbc >> > 3. restarted the CF service. >> > 4. reboot (grasping at straws here) >> > >> > Anyone have additional suggestions? >> > >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
