odbc_columns, odbc_primarykeys problem with Access Database file.
Currently, I am working on an Access db file, and try to get all fields name in one table by using odbc_columns. But whatever I tried, I could not figure out the use of this function. the following is the code I tried.
$ColList = odbc_columns($ConStr,$DbFile);
//This works and it returns all of the columns in the Access DB file.
$ColList = odbc_columns($ConStr,$arg_2,"%","PROJECT");
$ColList = odbc_columns($ConStr,$arg_2,"","PROJECT");
$ColList = odbc_columns($ConStr,$arg_2,"%","%");
//these two did n0t work with me. I can not get the fields in one table or all tables.
Also, the odbc_primarykeys has the same problem for me.
Thanks in advance!
zhlhh