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.
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
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
Pete wrote:
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
Looks like your driver is in the wrong dir. Are you running single- or
should give me a clean version of CF to work with. This is the first time I
have tried to anything with CF7 Enterprise.
P
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 29 May 2007 11:44 PM
To: CF-Talk
Subject: Re: CF Server connecting to MySQL v5
Pete
I know this isn't the most elegant solution, but it works. You can use the
mySQL v3.x driver that comes built into cf administrator if you apply one quick
fix to your mySQL user account:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
More on this can be found here:
This worked for me ...
http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7
HTH
Bob
-Original Message-
From: Pete [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 7:17 AM
To: CF-Talk
Subject: CF Server connecting to MySQL v5
Hi All
I have been using CF
Are you using CF 7 Standard or enterprise.
Where did you copy the jar file to if using Enterprise version?
Regards
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 30 May 2007 1:15 AM
To: CF-Talk
Subject: RE: CF Server connecting to MySQL v5
:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 4:24 PM
To: CF-Talk
Subject: RE: CF Server connecting to MySQL v5
Are you using CF 7 Standard or enterprise.
Where did you copy the jar file to if using Enterprise version?
Regards
-Original Message-
From: Bob Imperial [mailto
Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 30 May 2007 6:47 AM
To: CF-Talk
Subject: RE: CF Server connecting to MySQL v5
I was using 7 standard at the time I found the blog entry on it, though I am
running 8 at the moment and copied the jar to C:\ColdFusion8\lib
as standard or including it in a similar place in the jrun folder or
both.
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 30 May 2007 6:47 AM
To: CF-Talk
Subject: RE: CF Server connecting to MySQL v5
I was using 7 standard at the time I found
Yes, though I don't think it's released yet, was on the beta program ;) I
can hardly wait, lots of new goodies to play with.
-Original Message-
From: Pete [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 6:33 PM
To: CF-Talk
Subject: RE: CF Server connecting to MySQL v5
Thanks
So you think I need to install mysql-connector-java-5.0.4-bin.jar
In both CF folder and JRun folder?
Thanks
P
-Original Message-
From: AJ Mercer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 30 May 2007 8:49 AM
To: CF-Talk
Subject: Re: CF Server connecting to MySQL v5
13 matches
Mail list logo