Dear All,
I have been continually getting the error:
PHP Warning: SQL error: , SQL state 00000 in SQLColumns
when I try and use the odbc_columns command on an Access Database.
For example:
$conn = odbc_connect("MyDragonNet", "", "") or die(odbc_error_msg());
$cols = odbc_columns($conn, "%", "", "users") or die(odbc_errormsg());
does not work (I have tried changing parameters to blank strings or back to "%" with no effect
The following code DOES work:
$conn = odbc_connect("MyDragonNet", "", "") or die(odbc_error_msg());
$cols = odbc_columns($conn) or die(odbc_errormsg());
So it is only when I try and specfiy a table.
Does anyone have any idea?
Thanks in advance,
Justin Hardman