Re: ODBC access denied in wampserver

The following lines set variable values: $mySQLServer = "localhost"; $mySQLUsername = "root"; $mySQLPassword = "root"; The following line then tries to connect: $con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword); Stay well Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...' ----- Original Message ----- From: "George Pitcher" <george.pitcher@publishingtechnology.com> To: "'Jacob Kruger'" <jacobk@mailzone.co.za> Sent: Monday, June 21, 2010 12:42 PM Subject: RE: [PHP-WIN] ODBC access denied in wampserver

Jacob, The comment (using password: NO) is telling you that no password is being presented to MySQL. Check your script where the password is entered into the login script. Cheers George -----Original Message----- From: Jacob Kruger [mailto:jacobk@mailzone.co.za] Sent: 21 June 2010 11:21 To: php-windows@lists.php.net Subject: [PHP-WIN] ODBC access denied in wampserver Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\spiraleye\sql.php on line 9 (Problem: Access denied for user 'ODBC'@'localhost' (using password: NO) Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\wamp\www\spiraleye\sql.php on line 15 Line 9 is the following: $con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword); Line 15 is the following: mysql_select_db($mySQLDB, $con); I initially had this issue while trying to connect with the default, blank password for user, root, but now set the password to something else using phpmyadmin, and it works via mysql-front, but still gives me the same error/issue when trying to access the database via a PHP page? Any thoughts? TIA Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...' __________ Information from ESET NOD32 Antivirus, version of virus signature database 5213 (20100621) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 5213 (20100621) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 5214 (20100621) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com