aaaaargh grr coldfusion mysql connection

[duncno1]

Hi

I am trying to connect a new databse mysql4.1 and colfusion 6.1. I have
followed the technote :
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

but i get the error:

[]java.sql.SQLException: No suitable driver available for emp, please check
the driver setting in resources file, error: com.mysql.jdbc.Driver
The root cause was that: java.sql.SQLException: No suitable driver available
for emp, please check the driver setting in resources file, error:
com.mysql.jdbc.Driverysql-connector-java-3.{n}-bin.jar file in the
cf_root/WEB-INF/lib directory

Can anyone please help. It would be much appreciated. Gonna chuck my laptop
through an open window soon!!!! Cheers in advance!
Duncan:confused;

[mpwoodward *TMM*]

duncno1 wrote:

> Hi
>
> I am trying to connect a new databse mysql4.1 and colfusion 6.1. I have
> followed the technote :
> [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]
>
> but i get the error:
>
> []java.sql.SQLException: No suitable driver available for emp, please check
> the driver setting in resources file, error: com.mysql.jdbc.Driver
> The root cause was that: java.sql.SQLException: No suitable driver available
> for emp, please check the driver setting in resources file, error:
> com.mysql.jdbc.Driverysql-connector-java-3.{n}-bin.jar file in the
> cf_root/WEB-INF/lib directory
>
> Can anyone please help. It would be much appreciated. Gonna chuck my laptop
> through an open window soon!!!! Cheers in advance!
> Duncan:confused;
>

That "no suitable driver" error means it can't find the driver. Try
putting the JAR file path and name (yes, include the actual file name of
the JAR file) in your CF classpath directly, or if that doesn't work,
you can try unjarring the jar file and putting the path to the exploded
jar file contents in your CF classpath.

Matt

--
Matt Woodward
Team Macromedia - ColdFusion

[paross1]

I recently followed the process described in the attached technote to configure
a MySQL database as a datasource for my MX 7 development server, and it worked
the first time.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url]

Phil

[duncno1]

:D Thanks guys sorted now! i owe you one. Have taken my laptop away from the window sill.