MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Retrieve Error Messages using odbc_errormsg()?

Answer:

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('ggl_SQL_SERVER','sa','GlobalGuideLine');

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

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: estggl_center.php
on line 6
Execution failed:
State: S0002
Error: [Microsoft][ODBC SQL

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To Execute a SQL Statement using odbc_exec()?How To Turn Off Warning Messages during PHP Execution?