You could click the link in the email you just replied to! :) I will paste again: http://ajlcom.instantspot.com/blog/index.cfm/2006/1/7/Connecting-to-MYSQL-50-with-ColdFusion-MX7
On 9/18/07, Jim Shepard <[EMAIL PROTECTED]> wrote: > > 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/ > -- ~Dave Shuck [EMAIL PROTECTED] http://daveshuck.instantspot.com
_______________________________________________ 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/
