#36650 [Opn->Bgs]: odbc_tables fails with SQLerror: , SQL state 0000
ID: 36650
User updated by: kerry dot eade at capellaconsulting dot co dot nz
Reported By: kerry dot eade at capellaconsulting dot co dot nz
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: Windows Server 2003
PHP Version: 5.1.2
New Comment:
Issue resolved. DB2 Issue not PHP (Of Course).
See below link for details and fix.
http://www-1.ibm.com/support/docview.wss?uid=swg21215626
Previous Comments:
------------------------------------------------------------------------
[2006-03-08 00:03:42] kerry dot eade at capellaconsulting dot co dot nz
Description:
------------
I have been successfully using the ODBC_COLUMNS and ODBC_TABLES
commands on DB2 7.2 and DB2 8.2 databases. These functions have been
working on both windows and unix platforms.
After updating DB2 8.2 with FP11 (No problems with any early FixPaks)
which also updated the ODBC driver these commands now produce an
error:
SQL error: , SQL state 00000
My understanding is this state indicates it was successful and normally
reported as a return value of SQL_SUCCESS.
Are these commands expecting a return value of SQL_SUCCESS and
incorrectly interpreting the return value SQLSTATE 00000 as an error?
Reproduce code:
---------------
$conn_string = odbc_connect($db_name,$db_user,$db_pass);
odbc_columns($conn_string,"","$schema","$table");
while($details=odbc_fetch_array($queryexe2))
{
$all_columns[] = "$table.".$details['COLUMN_NAME'];
}
Expected result:
----------------
Produces a list of columns in the selected table.
Actual result:
--------------
Warning: odbc_columns() [function.odbc-columns]: SQL error: , SQL state
00000 in SQLColumns in c:\program files\apache
group\Apache\htdocs\mrs_prod\mrsscripts\make_report.php on line 548
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36650&edit=1
Thread (2 messages)