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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
