PHP :: Bug #12371 :: SQLColumns Error when using odbc

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

[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.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2025 The PHP Group All rights reserved.	Last updated: Tue May 06 12:01:29 2025 UTC