Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - odbc_errormsg() - Retrieving ODBC Error Messages

By: FYIcenter.com

(Continued from previous topic...)

How To Retrieve Error Messages using odbc_errormsg()?

When you call odbc_exec() to execute a SQL statement, and the execution failed on the SQL Server, you can use odbc_error() and odbc_errormsg() to retrieve the error code and error messages.

The tutorial script below shows you a good example:

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');

  # dropping a table
  $sql = 'DROP TABLE fyi.center';
  $res = odbc_exec($con, $sql);
  if (!$res) {
    print("Execution failed:\n");
    print("   State: ".odbc_error($con)."\n");
    print("   Error: ".odbc_errormsg($con)."\n");
  } else {
    print("Execution was successful.\n");
  }

  odbc_close($con); 
?>

If you run this script for the first time, you will get this output:

Execution was successful.

If you run this script again, the SQL statement will fail on the SQL Server, and you will get:

Warning: odbc_exec(): SQL error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]
Cannot drop the table 'fyi.center', because 
it does not exist or you do not have permission., 
SQL state S0002 in SQLExecDirect in C:\test\fyi_center.php
on line 6
Execution failed:
   State: S0002   
   Error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Cannot drop the table 'fyi.center', because it does not 
exist or you do not have permission.

(Continued on next topic...)

  1. What Are the Requirements to Use ODBC Connections in PHP Scripts?
  2. What Are Commonly Used ODBC Functions in PHP?
  3. How To Test ODBC DSN Connection Settings?
  4. How To Connect to a SQL Server using odbc_connect()?
  5. How To List All DSN Entries on Your Local Machine using odbc_data_source()?
  6. How To Execute a SQL Statement using odbc_exec()?
  7. How To Retrieve Error Messages using odbc_errormsg()?
  8. How To Turn Off Warning Messages during PHP Execution?
  9. How To Receive Returning Result from a Query?
  10. How To Loop through Result Set Objects using odbc_fetch_row()?
  11. How To Retrieve Field Values using odbc_result()?
  12. How To List All Tables in the Database using odbc_tables()?
  13. How To List All Columns in a Table using odbc_columns()?
  14. How To Create Prepared Statements using odbc_prepare()?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...