⟩ 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('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
