Adding MySQL 4/5 driver for cfide in CF7?

[CherylY279]

Hi,

I have done a search but not found my solution so I apologize if this has come up before. On one machine I have CF9 which appears to have come with a driver for MySQL (4/5) which I can use to create a data source to a MySQL 5.1 database. Unfortunately now I have to do the same on a box with CF7 - here I see only an option for MySQL 3.x. Does anyone know where I can find the proper driver that will work in cfide for CF7? Please let me know.

Thx,

Cheryl

[Dave Watts]

You'll have to download JDBC drivers for MySQL from mysql.com, place the JAR file for the driver in the appropriate directory, then choose "Other" from the list of database types and enter the appropriate JDBC URL.

How to install a database driver:

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7fe6.html

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on

GSA Schedule, and provides the highest caliber vendor-authorized

instruction at our training centers, online, or onsite.

Read this before you post:

http://forums.adobe.com/thread/607238

[-__cfSearching__-]

It has been a while since I have used MX7. But you can download a driver from the mySQL site and should be able to create a datasource of type "other"

http://dev.mysql.com/downloads/connector/j/

http://kb2.adobe.com/cps/025/6ef0253.html