Try using ODBC Socket in CFAdmin to create the datasource. I had a problem similar to this when I installed CFMX, but never in CF5...
YMMV will ----- Original Message ----- From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 2:54 PM Subject: MySQL ODBC Problem > 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
