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:231468 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
