#21076 [NEW]: ODBC_TABLES and ODBC_COLUMNS cannot be called together

[heyjohnlim]

From:             [EMAIL PROTECTED]
Operating system: Win2000, IIS-CGI
PHP version:      4.2.3
PHP Bug Type:     ODBC related
Bug description:  ODBC_TABLES and ODBC_COLUMNS cannot be called together

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 bug report at http://bugs.php.net/?id=21076&edit=1
-- 
Try a CVS snapshot:         http://bugs.php.net/fix.php?id=21076&r=trysnapshot
Fixed in CVS:               http://bugs.php.net/fix.php?id=21076&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=21076&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=21076&r=needtrace
Try newer version:          http://bugs.php.net/fix.php?id=21076&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=21076&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=21076&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=21076&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=21076&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=21076&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21076&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=21076&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=21076&r=isapi