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

ID: 21076 User updated by: heyjohnlim@yahoo.com Reported By: heyjohnlim@yahoo.com -Status: Bogus +Status: Open Bug Type: ODBC related Operating System: Win2000, IIS-CGI -PHP Version: 4.3.0RC3 +PHP Version: 4.3.0 New Comment: Hi Thanks for testing. I just retested. When i test with MS Access driver the problem does not occur. In the original report, I tested on microsoft sql server 2000, with SQL Server ODBC Driver version 2000.81.9001.00 (MDAC 2.6 installed). I just retested and still get the problem. I set the "Use ANSI quoted identifiers" and "Use ANSI nulls" in the odbc driver. - John Previous Comments: ------------------------------------------------------------------------ [2003-01-24 16:18:40] kalowsky@php.net 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. ------------------------------------------------------------------------ [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