Nothing too weird. Since the MyODBC configuration applet can connect and I can connect from CF when I pass a username and password, I have to assume the MySQL end of things is OK.
Apparently when specifying username and password attributes in CF's <cfquery> tag, these overide the settings in the System DSN configuration (which makes sense). When they're _not_ present in the tag it appears that CF still overides them and passes username="ODBC", and a blank(?) password. ----- Original Message ----- From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 4:01 PM Subject: Re: MySQL ODBC Problem > check in the mySQL permissions tables on the mysql server and look for any weirdness in the user, db and table permissions tables? > > restart mysql for any changes to take effect. > > ------------------------------------------- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > ------------------------------------------- > > > ---------- Original Message ---------------------------------- > From: "Jim McAtee" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 1 Jul 2003 15:54:33 -0600 > > >Han anyone run into this? > > > >I've got a W2k server running MySQL. I set up a MySQL database with a couple > >of tables and a MySQL user with password and access to that database. > > > >On another server running CF5 I install MyODBC 3.51 and create a System DSN > >pointing at the MySQL database. I enter the username and password matching the > >one above. > > > >Testing from the ODBC configuration applet, it successfully connects to the > >database. From CF, though, I can't connect to the database unless I don't > >supply a username and password. The error message returned suggests that the > >ODBC connection either isn't passing the correct username, or else it isn't > >passing a password. > > > >[MySQL][ODBC 3.51 Driver]Access denied for user: '[EMAIL PROTECTED]' (Using > >password: NO) > > > >When I specify a username and password in CF's <cfquery>, it works fine. I > >could work with this, but I'm used to setting up the username/password in the > >DSN and would prefer not to have my application do this. > > > >Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
