From: [EMAIL PROTECTED] Operating system: Win 2000 PHP version: 4.0.6 PHP Bug Type: ODBC related Bug description: SQLColumns Error when using odbc_columns on Oracle DB 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 bug report at: http://bugs.php.net/?id=12371&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]