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
