Yes I know that
I have been doing that but keep getting an error as shown below: Connection verification failed for data source: bluecattledog java.sql.SQLException: No suitable driver available for bluecattledog, please check the driver setting in resources file, error: null The root cause was that: java.sql.SQLException: No suitable driver available for bluecattledog, please check the driver setting in resources file, error: null I found the following information relating to this issue: Follow the below steps: 1) Download the MySQL Connector J JDBC driver from http://dev.mysql.com/downloads/connector/j/ 2) Make the JDBC driver available to CFMX through the classpath by saving mysql-connector-java-3.0-bin.jar in either $CFMX_HOME/runtime/servers/lib/ for CFMX Server Configuration or $JRUN_HOME/servers/lib/ for CFMX on JRun Configuration. This makes the driver available to all JRun server instances. 3)Restart CFMX server. Now I don't have a folder called $CFMX_HOME/runtime/servers/lib or $JRUN/HOME/servers/lib So I have copied the file to the following places: CFusionMX7>wwwroot>web-inf>lib and also to JRun4>servers>lib And restarted CF server Still waiting now to see what happens - was unable to connect to the JRun server? Regards -----Original Message----- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 May 2007 10:19 PM To: CF-Talk Subject: Re: CF Server connecting to MySQL v5 Got to add a data source - enter a name and select other JDBC URL: jdbc:mysql://<servername>:3306/<databasename> Driver Class: com.mysql.jdbc.Driver Driver Name: com.mysql.jdbc.Driver User Name : <usr> Password: <pwd> On 5/29/07, Pete <[EMAIL PROTECTED]> wrote: > > Hi All > > > > I have been using CF v7.02 standard for some time and have recently > installed CF 7 enterprise. > > > > I am unable to connect to a MySQL v5 database. > > > > I have added the mysql-connector-java file as I had to in CF v7.02. But I > am still however unable to connect to a MySQL datasource. > > > > Any ideas. > > > > Regards > > > > P > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4