English English Spanish EspañolKorea한국어
Straker»Company»Blog»2005» How to use MySQL 4.1 with ColdFusion MX

How to use MySQL 4.1 with ColdFusion MX

This technote is for you if you need to get MySQL Server 4.1 working with CFMX 7, To connect to a MySQL 4.1 database from ColdFusion MX:
  1. Download a current, stable version of the MySQL Connector JDBC driver, available at: http://dev.mysql.com/downloads/connector/j/ (documentation at: http://dev.mysql.com/doc/connector/j/en/index.html)
  2. Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded archive file.
  3. Save the mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib directory.
  4. Restart the ColdFusion MX server.
  5. Add a new data source to the ColdFusion MX Administrator, using the driver option Other.
  6. Enter the JDBC URL: jdbc:mysql://[host]:[port]/[database]
  7. Enter the Driver Class: com.mysql.jdbc.Driver
  8. Complete username/password, and adjust other data source settings, if needed.
  9. Submit the data source for verification.

More on: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253

Comments

There are no comments for this page as yet.

Add a comment