This is probably a shot in the dark as many people seem to have had the same problem and no-one seems to know what the answer is.
I'm using ODBC to connect to an MSAccess database and need to use the odbc_foreignkeys() function to discover the primary keys in other tables that are referenced by the foreign keys in one table.
e.g. $res = odbc_foreignkeys($dbh,"","","","%","Admin","Bid");
It seems however that any combination of 'wild card' characters or "" will produce
the error:
Warning: SQL error: , SQL state 00000 in SQLForeignKeys in C:\InetPub\wwwroot\Emily\Test.php on line 11
Admin in the table owner, Bid is the table name. If anyone could help with either an answer or an alternative solution, I would be eternally grateful.
Emily
I'm using ODBC to connect to an MSAccess database and need to use the odbc_foreignkeys() function to discover the primary keys in other tables that are referenced by the foreign keys in one table.
e.g. $res = odbc_foreignkeys($dbh,"","","","%","Admin","Bid");
It seems however that any combination of 'wild card' characters or "" will produce
the error:
Warning: SQL error: , SQL state 00000 in SQLForeignKeys in C:\InetPub\wwwroot\Emily\Test.php on line 11
Admin in the table owner, Bid is the table name. If anyone could help with either an answer or an alternative solution, I would be eternally grateful.
Emily