php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #12371 SQLColumns Error when using odbc_columns on Oracle DB
Submitted: 2001-07-25 13:20 UTC Modified: 2002-05-21 23:03 UTC
From: john_tipton at urscorp dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.6 OS: Win 2000
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: john_tipton at urscorp dot com
New email:
PHP Version: OS:

 

 [2001-07-25 13:20 UTC] john_tipton at urscorp dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-05-21 23:03 UTC] 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.
 [2002-05-22 09:19 UTC] john_tipton at urscorp dot com 
I've upgraded since then and don't seem to be having any problems.  Thanks
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Nov 05 06:00:01 2025 UTC