Skip to main content
Inspiring
December 16, 2008
Question

Coldfusion 8 driver for Mysql

  • December 16, 2008
  • 2 replies
  • 866 views
These are the data source settings now on a server box we want to replace. So we're setting up CF 8 on a new server and using Packaging & Deployment to move the data source information from the old box with CF 8 to the new box with CF 8. Can I just use the driver Mysql (4/5)? And what is the "Driver Class" line? The MySQL database is on a Linux box.

JDBC URL jdbc:mysql://<servername>/<pagename>?zerDateTimeBehavior=ConvertToNull

Driver Class com.mysql.jdbc.Driver
This topic has been closed for replies.

2 replies

BKBK
Community Expert
Community Expert
December 16, 2008
Can I just use the driver Mysql (4/5)? And what is the "Driver Class" line?

I don't think you need to specify the driver class when you use the built-in driver, MySQL (4/5). Setting the datasource should proceed like this

Add New Data Source
=====================
Data Source Name: MyDSN
Driver: MySQL(4/5)

Press Add button. It takes you to the next page.

CF Data Source Name:MyDSN
Database: myDatabase
Server:127.0.0.1
Port:3306
Username:CFMySQLAccount
Password:pw4CFonMySQL


Inspiring
December 16, 2008
Just use the MySQL 4/5 type

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"sbudlong" <webforumsuser@macromedia.com> wrote in message news:gi8bul$5kf$1@forums.macromedia.com...
> These are the data source settings now on a server box we want to replace. So
> we're setting up CF 8 on a new server and using Packaging & Deployment to move
> the data source information from the old box with CF 8 to the new box with CF
> 8. Can I just use the driver Mysql (4/5)? And what is the "Driver Class" line?
> The MySQL database is on a Linux box.
>
> JDBC URL jdbc:mysql://<servername>/<pagename>?zerDateTimeBehavior=ConvertToNull
>
> Driver Class com.mysql.jdbc.Driver
>
>