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

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

Can you please try one of the RCs?


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

[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 (#27992) next »