i asked the same question ages ago on this list and mark stanton replied
Supported version: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 Unsupported version: http://www.barneyb.com/blog/archives/000436.jsp Download: http://dev.mysql.com/downloads/connector/j/3.1.html On 3/20/06, Mike Kear <[EMAIL PROTECTED]> wrote: > > > 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 > > -- www.gavcooney.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---