#21844 [Com]: ODBC_CULUMNS problems

ID: 21844 Comment by: rickw@ednet.co.uk Reported By: rickw@ednet.co.uk Status: Feedback Bug Type: ODBC related Operating System: W2K PHP Version: 4.2.3 New Comment: Thanks for that although Im sure thats not it. Ive tried every variation of; -- $cols = odbc_columns($conn, "%", "", "[table]"); -- as reported on this site and phpbuilder. Also, elsewhere Im using -- $query = "WHERE Surname LIKE '$search_val%';" ^ -- with no problems. But maybe it handles this differantly. I have seen hoards of postings about this but no official line from the good people at php.net. Knock up a quick access table and test it yourself... you'll see what I mean. Rick. Previous Comments: ------------------------------------------------------------------------ [2003-01-23 10:25:56] kalowsky@php.net 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. ------------------------------------------------------------------------ [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