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 involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
