[cfaussie] Is there a trick to making MySQL play with CFMX7?

[Mike Kear]

Is there a trick or perhaps an 'undocumented feature" involved in getting MySQL 4.1 to play as a datasource for CFMX7?

 

I have the database installed.

I have accessed it with MySQL manager, and can see the data in the database.

I have downloaded the MySQL Connector J JDBC driver from the MySQL.com site.

I have installed v 3.1.12 version, then read in the AdobeLabs technote that there's a bug in that version.

So i downloaded connector v 3.0.17-ga

I copied file mysql-connector-java-3.0.17-ga-bin.jar  to C:\CFusionMX7\wwwroot\WEB-INF\lib 

I restarted coldfusion.  In fact I restarted my whole machine.

I added a CF Datasource using datasource?Other - the following properties:

 

datasourcename: MerlinMySQL

JDBC Url:  jdbc:mysql://localhost:3306/mydatabase

Driver Class:  com.mysql.jdbc.Driver

Driver Name:    <nothing - what goes in here?>

User Name:   root

Password:     mypassword

 

 

and with all that,  following the steps in the technote (I thought)   i get the following error message:

 

[quote]

Connection verification failed for data source: MerlinMySQL
java.sql.SQLException: No suitable driver available for MerlinMySQL, please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available for MerlinMySQL, please check the driver setting in resources file, error: null
[/quote]

 

Did I miss something?     Is there another little trick involved?

--
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---