odbc_errormsg

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

Returns a string containing the last ODBC error message, 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_error() and odbc_exec().

Examples ( Source code ) » odbc_errormsg


<?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_errormsg

phobo

The odbc_errormsg() function was added in PHP 4.0.5 To get odbc error messages before that, use the $php_errormsg global and turn Track Errors ON in php.ini

Change Language

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

odbc_errormsg

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

Code Examples / Notes » odbc_errormsg

Change Language

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