Re: Access denied for user 'ODBC'@'localhost'
I’m using
MySQL 4.1.8 with MyODBC version 3.51.10-2 and a Microsoft Windows XP Professional Service Pack 2 platform.
When trying to open the connection to the MySQL Server via ODBC with ASP I get the following error from the ODBC object "[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)"
When setting up the ODBC driver the connection test was successful, and the drop do that allows you to select a starting table was correctly populated indicating that that connection was genuinely made.
I specified the users name and password for the root user account in the ODBC driver, and so I am unsure as to why the error message appears to be attempting to logon as 'ODBC'. If there needs to be an 'ODBC' user account to allow the ODBC driver to look up other accounts this is not mentioned anywhere.
Hope someone can help, as like a number of people in the forum I am thinking of having to go back to a slightly earlier version of the server and driver.
Subject
Written By
Posted
November 25, 2004 01:48PM
November 25, 2004 04:15PM
November 26, 2004 05:54AM
November 13, 2007 03:06AM
September 17, 2008 04:01AM
November 26, 2004 10:20AM
November 28, 2004 04:38AM
November 29, 2004 08:24PM
December 25, 2004 12:58AM
November 30, 2004 09:48PM
December 02, 2004 11:36AM
December 02, 2004 11:44AM
December 03, 2004 01:57AM
December 06, 2004 11:16AM
December 19, 2004 12:15AM
Re: Access denied for user 'ODBC'@'localhost'
January 12, 2005 11:40AM
November 25, 2005 11:30PM
November 26, 2005 03:47AM
November 25, 2005 08:00PM
November 15, 2008 10:59AM
September 27, 2005 06:55AM
September 27, 2005 06:57AM
September 19, 2005 10:55AM
November 01, 2005 01:23PM
November 23, 2005 03:42AM
December 12, 2005 10:15AM
December 18, 2007 02:48AM