What version of ColdFusion are you running. There is a special connector that you may ahve to install to enable you to connect to a MySQL database.
It is the mysql-connector-odbc-3.51.21-win32 available form the MySQL website. Download it and instal and then you also have to place a copy in a folder in CF, the lib folder but you better check on that one. Hope that helps a little. T >I can't create a mysql datasource in CF Administrator. > >If I use the following datasource settings in CF Administrator: > >JDBC URL: jdbc:mysql://localhost:3306/test >Drive Class: MySQL Connector J > >AND (note the emphasis) I set my local and remote folders in my DW site >local folder, remote folder and testing server folders all to >C:\CFusionMX\db\, I can connect to my mysql database in CF Administrator. > >However, with these DW site folder settings, DW doesn't recognize any >databases (Access or Mysql) at all. > >When I change my DW site folder settings to 'wwwroot' (e.g.local folder >C:\CFusionMX\db\' is changed to 'C:\CFusionMX\wwwroot') DW now lists all >my CF Administrator databases. > >The problem is CF Administrator can't connect to my Mysql data sources. It >gives me the error: > >"Connection verification failed for data source: javaserver >[]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" > >I've tried changing the 3306 port to 8500, but this doesn't help. > >My java path and connector file is: >C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar, > >Is this a ID/password problem? I've tried both 'root' and leaving the ID >field in the CF Administrator add data source block, both to no avail. I >don't have a password set in Mysql for 'root' either. > >Any help would be gratefully appreciated. I've been working on this for >weeks and keep running into one problem after another. > >Thanks a million in advance. > >Sincerely, > >Graham A. Kerby ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
