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]

Reply via email to