Go to mysql and download the ConnectorJ. I've found that to be the only really reliable connection method.
-----Original Message----- From: Matt Osbun [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 12:42 PM To: CF-Talk Subject: RE: Setting up MySql Data Source I ran into this problem a few months ago, unfortunately at a previous job, so I don't have access to all my documents/notes/DL'd files for fixing this. Basically though, if you are using a version of MySQL later than (I think) 4.0, you may need to download a different connector than what CF6.1 provides pre-packaged. Try downloading the lastest from http://dev.mysql.com/downloads/connector/ and following the instructions at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170 Hope this helps Matt Osbun Web Developer Health Systems, International -----Original Message----- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 1:12 PM To: CF-Talk Subject: Re: Setting up MySql Data Source Actually I checked the port at 3306 and that appears fine. I am using localhost for the server setting? Should I use something else? > I just loaded MySql to my development machine. I have MySql up and > running and even created the database I will be using. I am trying to set up a DSN in CFAdmin but it keeps failing. Since this is a non-server machine do I have to change the port? > > my error > > Connection verification failed for data source: bvhdku > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. > The root cause was that: java.sql.SQLException: SQLException occurred > in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200251 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
