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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
Yep it exists.
------------------------------------------------------------------------
[2003-02-19 23:35:38] [EMAIL PROTECTED]
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
