Tried that also :-(
-----Original Message----- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 3:31 PM To: CF-Talk Subject: Re: MySQL/CFMX7 is the death of me. <cf_stab_in_the_dark> This might sound dumb but try changing localhost to 127.0.0.1 in this part: jdbc:mysql://localhost:3306/myDevDB </cf_stab_in_the_dark> Just guessing, I had probs with verity and the fix was changing localhost to 127.0.0.1 Dave On Feb 6, 2006, at 12:32 PM, Adkins, Randy wrote: > 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! > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231489 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
