How do I find Aarons Blog. Jim Shepard On Tue, 18 Sep 2007 14:15:39 -0500, "Dave Shuck" <[EMAIL PROTECTED]> said: > Our very own Aaron Lynch also has a nice blog entry on connecting to > MySQL 5 > with ColdFusion: > Connecting to MYSQL 5.0 with ColdFusion > MX7<http://ajlcom.instantspot.com/blog/index.cfm/2006/1/7/Connecting-to-MYSQL-50-with-ColdFusion-MX7> > > On 9/18/07, Joe Kelly <[EMAIL PROTECTED]> wrote: > > > > Trying to play with Dave's Mach-II code (as well as some others), I > > thought I'd post the solution to a problem I encountered as I'm sure > > that many of you trying to set up a MySQL data source on CF7 will run > > into this issue. > > > > Having been a while since installing MySQL on a windows box and trying > > to set up a MySQL datasource through the CF7 administrator. I came up > > with this error: > > > > Connection verification failed for data source: mysql_bad > > 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? > > > > Per the Adobe TechNote for CF MX, http://www.adobe.com/go/6ef0253 you > > will need to follow these steps to set up your MySQL db for CF. > > > > To connect to a MySQL 4.1 or 5 database from ColdFusion MX: > > > > 1. Download a current, stable version of the MySQL Connector J JDBC > > driver, available at: http://dev.mysql.com/downloads/ > > > > Note: Connector/J version 3.1.11 and higher cannot be used with > > ColdFusion MX 7 because of MySQL bug 13469. Connector/J 3.1.10 should > > be used instead for ColdFusion MX 7 until this MySQL bug is fixed. All > > Connector/J version 3.0 releases and all version 3.2 releases work > > with ColdFusion MX 7. > > 2. Extract the mysql-connector-java-3.{n}-bin.jar file from the > > downloaded archive file. > > 3. Save the mysql-connector-java-3.{n}-bin.jar file in > > thecf_root/WEB-INF/lib directory. > > 4. Restart the ColdFusion MX server. > > 5. Add a new data source to the ColdFusion MX Administrator, using > > the driver option Other. > > 6. Enter the JDBC URL: > > jdbc:mysql://[host]:[port]/[database] > > 7. Enter the Driver Class: > > com.mysql.jdbc.Driver > > 8. Complete username/password, and adjust other data source > > settings, if needed. > > 9. Submit the data source for verification. > > > > The exception being, to use the latest MySQL Connector. > > I hope this helps anybody who runs into this problem! > > Thanks, > > Joe Kelly > > > > _______________________________________________ > > Reply to DFWCFUG: > > [email protected] > > Subscribe/Unsubscribe: > > http://lists1.safesecureweb.com/mailman/listinfo/list > > List Archives: > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > http://www.mail-archive.com/list%40dfwcfug.org/ > > DFWCFUG Sponsors: > > www.instantspot.com/ > > www.teksystems.com/ > > > > > > -- > ~Dave Shuck > [EMAIL PROTECTED] > http://daveshuck.instantspot.com -- Jim Shepard [EMAIL PROTECTED]
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
