Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : ODBC Functions (Unified) : odbc_error

odbc_error

Get the last error code (PHP 4 >= 4.0.5, PHP 5)
string odbc_error ( [resource connection_id] )

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 FALSE).

See also: odbc_errormsg() and odbc_exec().

Examples ( Source code ) odbc_error

<?php

        $connection_string 
'DRIVER={SQL Server};SERVER=<servername>;DATABASE=<databasename>';
        
$user 'username';
        
$pass 'password';
        
$connection odbc_connect$connection_string$user$pass );
        if (
odbc_error())
        {
              echo 
odbc_errormsg($conn);
        }
        
// if you want to show the perfect error message
        // then format it using string functions.
?>

Code Examples / Notes » odbc_error

sergio 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 Language


Follow Navioo On Twitter
odbc_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
eXTReMe Tracker