#1, why are you using mysql root to login? Bad Jon, no cookie. #2, use the grant statement to make yourself a real account. Make sure that you have permission from MySQL to connect from a remote machine.
GRANT (PERM) on database.table to user@'ipaddress' identified by 'password' More documentation: http://www.mysql.com/doc/G/R/GRANT.html Try that and see if it works. MySQL is very picky about who can connect from what host (as it should be). It might be part of your problem. ~Todd On Sat, 22 Jun 2002, Jon Krawczuk wrote: > Yes that's what I mean. I can connect to this ODBC source outside of > CF5, but not through RDS > > Outside result: > > 'MySQL ODBC 3.51 Driver: 03.51.02 > DataSource 'home_contacts' Connected Successfully to 'mysqld-3.23.49' > !!! > OK' > > > But then get this trying to use RDS: > > 'Remote Server Operation Failure: > The connection with the server was reset > OK' > > > Near as I can tell the settings match those of the MySQL table I'm > connecting to. > I've doubled backed a dozen times, same result each time. > > Description: contacts > Host name:172.16.213.39 > Port: 3306 > > User Name: root > Password: > > Anyone seen a similar issue? > I am using Win2k professional connecting to a W2k server, CF5 Studio. > > Sorry for the double post, I included screen grabs in the first but they > were stripped out. > > Jon Krawczuk > -- ============================================================ Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator) | http://www.ultrashock.com/ - webRat (Back-end Moderator) | ============================================================ ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
