Im no expert here, so take my advice with a grain of salt. I put the 3.1.12 driver (mysql-connector-java-3.1.12-bin.jar) in my C:\CFusionMX7\wwwroot\WEB-INF\lib folder and then restarted. I dont see the mysql connector in my class path in the cfadmin.
I am also using mysql 5.0.something. Are you sure you put the driver in the same place? I have also had problems before with beta drivers from mysql. On 2/6/06, Adkins, Randy <[EMAIL PROTECTED]> 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:231472 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