#21844 [Opn->Fbk]: ODBC_CULUMNS problems

ID: 21844 Updated by: kalowsky@php.net Reported By: rickw@ednet.co.uk -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: W2K PHP Version: 4.2.3 New Comment: If I remember correctly the issue isn't the MS driver, or the code, but the Access JET engine. The '%' driver I believe is not supported by the JET engine and as such fails on all attempts. Unfortunately I can't test to prove it right now, so give that a try. Previous Comments: ------------------------------------------------------------------------ [2003-01-23 09:23:25] rickw@ednet.co.uk Im using Access 2k with PHP 4.2 win32 binary. Im simply trying to query the columns in a table, thus; -- $conn = odbc_connect( 'DSN_NAME', 'root', '' ); $cols = odbc_columns($conn, "%", "", "[table]"); -- This returns the error; -- Warning: SQL error: , SQL state 00000 in SQLColumns in ...... -- I have seen previous postings in various places regarding this issue but no mentions of a fix/workaround anywhere??? Whats the problem with this? Is it the odbc drivers for windoze or somthing code related (although the above follows the manual to a 't')? Cheers, Rick. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21844&edit=1