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

ID: 21076 Updated by: kalowsky@php.net Reported By: heyjohnlim@yahoo.com -Status: Open +Status: Bogus Bug Type: ODBC related Operating System: Win2000, IIS-CGI PHP Version: 4.3.0RC3 New Comment: Marking as bogus. Using Win2k, and the CGI build I cannot reproduce this at all. My attempts to showed nothing wrong with the code base that I could find. Previous Comments: ------------------------------------------------------------------------ [2002-12-22 00:56:28] iliaa@php.net Updating version. ------------------------------------------------------------------------ [2002-12-19 05:57:03] heyjohnlim@yahoo.com yes it still happens with 4.3.0 rc3. Regards, John ------------------------------------------------------------------------ [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