Collections:
odbc_errormsg() - Retrieving ODBC Error Messages
How To Retrieve Error Messages using odbc_errormsg()?
✍: Guest
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.
⇒ Turning Off PHP Warning Messages for ODBC Connection
⇐ odbc_exec() - Executing SQL Statements
⇑ SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution
2023-12-31, 1211🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...