MySQL+CFMX7

__To get a datasource working:__

Get the driver into ColdFusion
- go to http://www.mysql.com/products/connector/j/ and download a connector zip.
- pull out the mysql-connector-java-X.X.X.bin.jar
- put it in the E:\\\CFusionMX7\\\wwwroot\\\WEB-INF\\\lib directory (If you just toss it in the root lib directory, it won't work)
- restart CF.

Add the DS
- add a DS as type 'other' with the info:
-- JDBC URL = jdbc:mysql://\[host]:\[port]/\[database]
-- Driver Class  = com.mysql.jdbc.Driver.

This is outlined for previous drivers in the page http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253


Comments