I know I'm not really answering your question, but I've had no problems with CFMX 7.0.1/MySQL 5. I followed the directions in the comments to Ben Forta's post on the MySQL 5 release, and all worked fine (I have done this on 3 different machines): http://www.forta.com/blog/index.cfm?mode=entry&entry=A61BD155-3048-80A9- EF63F5397C4511AA
> -----Original Message----- > From: Adkins, Randy [mailto:[EMAIL PROTECTED] > Sent: Monday, February 06, 2006 11:33 AM > To: CF-Talk > Subject: MySQL/CFMX7 is the death of me. > > Ok for those of you who are familiar with this thread. > > I backed out of the 5.0 beta connectors from MySQL > and loaded the 3.1.12 connectors. > > How I did this was deleted all the 5.0 jar files from the > system. Then used the System Information are to update > the jar file for the 3.1.12 connectors. > > Restarted the machine each time. Viewed the classpath > area under System Information (CFMX7) and only found the > new drivers for 3.1.12. So the 5.0 BETAs are gone. > > So I am thinking GREAT! Now I have the 3.1.12 drivers loaded. > BTW: This is CFMX 7.0.1 > > So I go to datasources, add a new datasource using Other as > people have mentioned using the following: > > JBDC URL: jdbc:mysql://localhost:3306/myDevDB > Driver Class: com.mysql.jdbc.Driver > Driver Name: [nothing entered here] > Username: root > Password: [rootlevelpassword] > > and when I click Submit Changes I get the following error: > > Connection verification failed for data source: myDevDB > java.sql.SQLException: Timed out trying to establish connection > The root cause was that: java.sql.SQLException: Timed out trying to > establish connection > > Now, I use NaviCat and I can connect locally using that GUI interface > for MySQL. > MySQL is 5.0.xxxx (sorry do not remember the actual number) I connect > just fine > and can add, edit, and update databases without a problem. > I can also use the Windows XP Control Panel to create the datasource > there and it > validates just fine, but not in CFMX 7. > > So any idea why in the world CFMX 7 has this issue? > > Thanks to all! This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231476 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
