#18628 [Opn->Csd]: odbc_columns returns SQL error 00000
ID: 18628
Updated by: kalowsky@php.net
Reported By: jeff.albert@ualberta.ca
-Status: Open
+Status: Closed
Bug Type: ODBC related
Operating System: Windows 2000 Professional
PHP Version: 4.2.2
New Comment:
Partially fixed.
In your first case, the '%' operator is not really handled at all by
MSAccess as far as I can tell. If you have proof otherwise, please
show me some documentation so I can fully fix this.
The crash case though is now fixed in the CVS. Try a snapshot and see
if this works for you.
Previous Comments:
------------------------------------------------------------------------
[2002-07-29 14:15:46] jeff.albert@ualberta.ca
Hello,
I will limit this report to odbc_columns, although other odbc functions
appear to be affected similarly:
<?php
$con = odbc_connect("dev", "", "");
$result = odbc_columns($con, "", "", "", "%");
?>
The above code will produce an SQL State 00000 error when connecting to
an MS Access 2000 database through ODBC on a Windows 2000 Professional
box. PHP is version 4.2.2, and the problem appears to occur in both
Apache 1.3.* and 2.0.39.
<?php
$con = odbc_connect("dev", "", "");
$result = odbc_columns($con);
?>
Calling odbc_columns without the extra parameters actually causes
php.exe to crash altogether under the same environment.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=18628&edit=1
Thread (4 messages)