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
