0 Replies Latest reply: Sep 22, 2009 11:55 AM by David_Powers RSS

    Access denied for ODBC/SYSTEM@localhost (using password: NO)

    David_Powers ACP

      When trying to insert or update records into a MySQL database, some people get an error message that looks similar to this:

      Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\htdocs\mysite\TMPbcn96qcid9.php on line 20

      The username might also be SYSTEM, instead of ODBC.

       

      The problem is that you're trying to interact with the database using a temporary file (the clue is in the file name, which begins with TMP). This prevents PHP from accessing the MySQL connection, resulting in access being denied.

       

      The solution is simple:

      1. Open the Preferences panel from the Edit menu (or Dreamweaver menu on a Mac).
      2. Select the Preview in Browser category.
      3. Deselect the option to preview using a temporary file.
        preview_not_temp.jpg
      4. Click OK.

       

      As long as your testing server definition and MySQL connection details are correct, you should now be able to insert and update records.