How To Retrieve Error Messages using odbc_errormsg()?
Submitted by: AdministratorWhen 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | What Happens If NULL Values Are Involved in Bitwise Operations? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | What Is a Subquery in a SELECT Query Statement in MS SQL Server? |
☺ | How To Use Subqueries with the IN Operators in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |