|
odbc_error
Get the last error code
(PHP 4 >= 4.0.5, PHP 5)
Returns a six-digit ODBC state, or an empty string if there has been no errors. If connection_id is specified, the last state of that connection is returned, else the last state of any connection is returned.
This function returns meaningful value only if last odbc query failed
(i.e. odbc_exec() returned See also: odbc_errormsg() and odbc_exec(). Examples ( Source code ) » odbc_error
Code Examples / Notes » odbc_errorsergio sartori
Using IBM DB2 V7.1 and MS SQL Server 7 ODBC database connections. Print the result of odbc_error() or odbc_errormsg() after each call to an odbc_ function that gives no error and, sooner or later, you'll get garbage instead of a blank string! aaronbair
If you use an argument, make sure its the CONNECTION_ID and not the RESULT_ID. Testing the result can return a null string or sometimes a garbage string. # -- Example code -- $rs = odbc_exec($dbc, $sql); #this is wrong but won't error out until #you demo the page for a client! if (odbc_error($rs)) die(...); #these work if (odbc_error()) die(...); if (odbc_error($dbc)) die(...); sunil_limje
I have use this function, its very simple and cute. with IBM DB2 <?php // you must set the connection first if (odbc_error()) { echo odbc_errormsg($conn); } // if you want to show the perfect error message // then format it using string functions. ?> Have a good day! |
Change Languageodbc_autocommit odbc_binmode odbc_close_all odbc_close odbc_columnprivileges odbc_columns odbc_commit odbc_connect odbc_cursor odbc_data_source odbc_do odbc_error odbc_errormsg odbc_exec odbc_execute odbc_fetch_array odbc_fetch_into odbc_fetch_object odbc_fetch_row odbc_field_len odbc_field_name odbc_field_num odbc_field_precision odbc_field_scale odbc_field_type odbc_foreignkeys odbc_free_result odbc_gettypeinfo odbc_longreadlen odbc_next_result odbc_num_fields odbc_num_rows odbc_pconnect odbc_prepare odbc_primarykeys odbc_procedurecolumns odbc_procedures odbc_result_all odbc_result odbc_rollback odbc_setoption odbc_specialcolumns odbc_statistics odbc_tableprivileges odbc_tables |