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? > >Thanks, >Jim > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
