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

ID: 21076 Comment by: php-louis at steelbytes dot com Reported By: jlim at natsoft dot com Status: No Feedback Bug Type: ODBC related Operating System: Win2000, IIS-CGI PHP Version: 4CVS, 5CVS New Comment: I just ran into this problem with latest PHP and MSDE2000 (SQL Server 2000 cut down editon). using somthing like the following does not work ... (pseudo code) $tables = odbc_tables($con) while ($t=$odbc_fetch_array($tables)) { odbc_columns($con,$t['TABLE_CAT'],$t['TABLE_SCHEM'],$t['TABLE_NAME']); <-- fails here display column results } but the following does work $tables = odbc_tables($con) while ($t=$odbc_fetch_array($tables)) array_push($tahbles_array,$t); odbc_free_result($tables); for (. $t in $tahbles_array .) { odbc_columns(..$t[name].) (as above) display column results odbc_free_result() } Previous Comments: ------------------------------------------------------------------------ [2004-04-21 00:13:29] iliaa@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2004-04-13 12:57:54] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2003-07-02 04:01:13] jlim at natsoft dot com Tested with 4.3.3RC2-dev. Same problem with mssql odbc driver. I also tested with access and oracle odbc drivers and the problem never happens with these drivers, so it appears to be something specific to the way mssql does things. I also double-checked the MDAC using M'soft's ComCheck program(as i have changed PC's), and it is mdac 2.7 SP1. The mssql driver version is 2000.81.9031.14, 15/Nov/2002 Regards, John ------------------------------------------------------------------------ [2003-06-29 22:45:57] kalowsky@php.net Yep it exists. ------------------------------------------------------------------------ [2003-02-19 23:35:38] kalowsky@php.net Well now that seems really odd. I guess I'll have to try to get access to a SQLServer machine for some testing... ugh... ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/21076 -- Edit this bug report at http://bugs.php.net/?id=21076&edit=1