#18628 [Csd]: odbc_columns returns SQL error 00000

ID: 18628 User updated by: jeff.albert@ualberta.ca Reported By: jeff.albert@ualberta.ca Status: Closed Bug Type: ODBC related Operating System: Windows 2000 Professional PHP Version: 4.2.2 New Comment: The latest snapshot appears to have fixed the crash problem entirely for all the affected functions including odbc_columns() and odbc_tables(). It appears that you are correct in asserting that % is not interpreted properly by the Access driver. Thanks for your help! Jeff Albert Previous Comments: ------------------------------------------------------------------------ [2002-08-12 20:39:19] kalowsky@php.net 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. ------------------------------------------------------------------------ [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