Bug #12371 Updated: SQLColumns Error when using odbc_columns on Oracle DB

ID: 12371 Updated by: john_tipton@urscorp.com Reported By: john_tipton@urscorp.com Status: Closed Bug Type: ODBC related Operating System: Win 2000 PHP Version: 4.0.6 New Comment: I've upgraded since then and don't seem to be having any problems. Thanks Previous Comments: ------------------------------------------------------------------------ [2002-05-21 23:03:19] kalowsky@php.net I don't understand how this sample script causes an error on lines 11 or 12 when it doesn't contain that many lines. Can you please try a newer version of PHP and if it continues please re-open the bug. ------------------------------------------------------------------------ [2001-07-25 13:20:52] john_tipton@urscorp.com I have tried all the different syntaxes I could think of and can't get odbc_columns to work with ORACLE on Win 2000. <?php $cnx=odbc_connect("cpen_sds",$username,$password); $res=odbc_columns($cnx,"cpen_sds","%","faqs"); odbc_result_all($res, "BGCOLOR='yellow' border=3 bordercolordark='#FF0000'"); odbc_close_all(); ?> I get the following error: Warning: SQL error: , SQL state 00000 in SQLColumns in E:\InetPub\websites\AMS\wwwroot\test3.php on line 11 Warning: Supplied argument is not a valid ODBC result resource in E:\InetPub\websites\AMS\wwwroot\test3.php on line 12 Thanks, John R. Tipton ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=12371&edit=1