Cold Fusion Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingCold Fusion Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 29th, 2010, 07:32 AM
bijayani bijayani is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2009
Posts: 8 bijayani User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 34 m 58 sec
Reputation Power: 0
Connect to MySQL 4.1 or any higher version MySQL database from ColdFusion 7 script

From ColdFusion if we need to connect to any database then we need to create datasource in ColdFusion server administrator. When we need to create datasource in ColdFusion 7 admin to connect to MySQL 4.1 or any higher MySQL version database we need to use the default MySQL Driver (from the list of driver options provided by ColdFusion 7). But it will throw an error, because the default driver is not supported in higher versions of MySQL.
The error occurs due to the fact that from MySQL 4.1 version, the authentication mechanism of MySQL has been changed, because of which older MySQL drivers would not be able to work unless and until the driver is updated to a current version or MySQL is configured to use the older authentication mechanism.
In order to connect to MySQL database with 4.1 or higher version, the following steps need to be performed:
1. Download a current version of MySQL driver
2. Unzip the zip file (if it is zipped)
3. Copy the .jar file in the ColdFusion instance to be used (into CFusionMX7/wwwroot/WEB-INF/lib/)
4. Restart the instance
5. Create a new datasource with 'Other' driver option
6. Enter the JDBC URL: jdbc:mysql://[host]:[MySQL port]/[database name]
7. Enter the Driver Class: com.mysql.jdbc.Driver
8. Provide the username and password for the database
9. Submit the datasource for verification
Any suggestions are welcomed.
Thanks

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingCold Fusion Development > Connect to MySQL 4.1 or any higher version MySQL database from ColdFusion 7 script


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap