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 May 30th, 2004, 06:42 AM
Mattastic Mattastic is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 8 Mattastic User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Using mySql as a datasource

Hi,

Can somebody tell me how to setup mysql so it works with coldfusion mx?

I've downloaded the odbc connector from here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

I've tried to verify the datasource in CF administrator, but it can't find it?

Am I doing it right?

Hope you can help.

Reply With Quote
  #2  
Old July 16th, 2004, 02:55 PM
adrapley adrapley is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 1 adrapley User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
you shouldn't need the ODBC connector. CFMX uses JDBC and actually includes JDBC drivers for MySQL. You just need to log in to the CF administrator, click 'datasources', enter a datasource name, and under 'Driver', select MySQL.

By default, CFMX Pro includes the drivers for MS SQL Server, and MySQL. CFMX Enterprise includes 3rd party JDBC drivers for several other type of databases like Oracle, Sybase, DB2, etc.

Reply With Quote
  #3  
Old September 19th, 2004, 12:26 PM
CF_N00b4hire CF_N00b4hire is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 1 CF_N00b4hire User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Talking

hey bud!

If you're using MySql on a windows box
you'll need to add a datasource in Windows.

Do this... Open the control panel in windows
(if you cant do this you need to learn windows before
you start cfml
Then click on Administrative tools, ODBC Data Sources,
Choose the "System" tab and click Add
Choose MySQL driver
Then fill out the info and click Test
to see if you have the passwords and whatnot right.
If it fails work with what you entered and fix it.
After that click OK and your new datasource should
be found by CF.

Have a great day!

Phillip

Reply With Quote
  #4  
Old September 21st, 2004, 07:08 AM
sara jay sara jay is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 1 sara jay User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by CF_N00b4hire
hey bud!

If you're using MySql on a windows box
you'll need to add a datasource in Windows.

Do this... Open the control panel in windows
(if you cant do this you need to learn windows before
you start cfml
Then click on Administrative tools, ODBC Data Sources,
Choose the "System" tab and click Add
Choose MySQL driver
Then fill out the info and click Test
to see if you have the passwords and whatnot right.
If it fails work with what you entered and fix it.
After that click OK and your new datasource should
be found by CF.

Have a great day!

Phillip

Hi, Phillip

I have a similar problem I can create a datasource
(using the method you mention) to the test database, but not to my own. I
get the error access denied to user @localhost for database 'my database'.
Any Ideas?

Kind Regards - Sara

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingCold Fusion Development > Using mySql as a datasource


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 - 2018, Jelsoft Enterprises Ltd.

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