Another question, when one enters the IP and port number in the RDS datasource setup, does RDS ask mySQL for a specific table to connect to at this point? I ask this as I can't seem to even get connected to a mySQL source running on the same machine. Previously described errors...
Jon Krawczuk -----Original Message----- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 8:57 AM To: CF-Talk Subject: RE: MySQL and CF Well, if you've covered all the bases, it might be. Not using CF5 atm so, I can't confirm. At 08:53 AM 6/22/2002 -0700, you wrote: >I can connect through ODBC, including a mySQL GUI, in this case >Premiumsoft NaviCat. I can connect using mysqlfront. > >I'm not sure it isn't the RDS interface with some errant ini parse. > >Jon Krawczuk > >-----Original Message----- >From: Todd [mailto:[EMAIL PROTECTED]] >Sent: Saturday, June 22, 2002 8:41 AM >To: CF-Talk >Subject: RE: MySQL and CF > >Another alternative is to try a different program and see if you can >connect. http://www.mysqlfront.de/ is a donateware MySQL gui. If >you're >still having problems connecting, try the grant statement I gave you. > >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/ Moderator @ FlashCFM.com - http://www.flashCFM.com/ Back-end Moderator @ Ultrashock.com - http://www.ultrashock.com/ ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
