#21076 [Fbk->Opn]: ODBC_TABLES and ODBC_COLUMNS cannot be called together

From: Date: Thu, 19 Dec 2002 11:57:03 +0000
Subject: #21076 [Fbk->Opn]: ODBC_TABLES and ODBC_COLUMNS cannot be called together
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-28019@lists.php.net to get a copy of this message 
 ID:               21076
 User updated by:  heyjohnlim@yahoo.com
 Reported By:      heyjohnlim@yahoo.com
-Status:           Feedback
+Status:           Open
 Bug Type:         ODBC related
 Operating System: Win2000, IIS-CGI
 PHP Version:      4.2.3
 New Comment:

yes it still happens with 4.3.0 rc3.

Regards, John


Previous Comments:
------------------------------------------------------------------------

[2002-12-18 14:00:48] kalowsky@php.net

Can you please try one of the RCs?

------------------------------------------------------------------------

[2002-12-18 07:54:50] heyjohnlim@yahoo.com

The following code:
<?php
error_reporting(E_ALL);

$conn = odbc_connect("netsdk", "yyyy", "xxxx") or die("FAIL
CONNECTION");
print "Connected <br>";
print "ODBC_Tables<br>"; 
	$trs = odbc_tables($conn); 
	odbc_free_result($trs);
print "ODBC_Columns<br>"; 
	$colrs = odbc_columns($conn); 
	odbc_free_result($colrs);
print "Done<br>";
?>

Will generate the output:

Connected 
ODBC_Tables
ODBC_Columns

Warning: SQL error: , SQL state 00000 in SQLColumns in
d:\inetpub\wwwroot\php\hs~a.php on line 10

Warning: odbc_free_result(): supplied argument is not a valid ODBC
result resource in d:\inetpub\wwwroot\php\hs~a.php on line 11
Done

However, the following code with odbc_tables commented out:

<?php
error_reporting(E_ALL);

$conn = odbc_connect("netsdk", "adodb", "natsoft") or die("FAIL
CONNECTION");
print "Connected <br>";
/*print "ODBC_Tables<br>"; 
	$trs = odbc_tables($conn); 
	odbc_free_result($trs);*/
print "ODBC_Columns<br>"; 
	$colrs = odbc_columns($conn); 
	odbc_free_result($colrs);
print "Done<br>";
?>

Works fine with the output:

Connected 
ODBC_Columns
Done

Hope this was clear.

Regards, John Lim

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=21076&edit=1

Thread (19 messages)

« previous php.bugs (#28019) next »