ID: 21844
Comment by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
