|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-03-13 01:37 UTC] kerry dot eade at capellaconsulting dot co dot nz
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 17:00:01 2025 UTC |
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