Hello friends,
I am not a master in the use of ODBC but what I can tell you is that the .DBC file does contain the names of the tables that conform the VFP database as well as its fields, defined indexes, stored procedures, etc. (However, as Cy explained on his reply, the actual data tables are stored separately on individual files). Try to USE YourDbc.DBC file and browse it. You will see that there are at least records for every table and each one of its fields. The OBJECTTYPE column tells you wether the record refers to a 'Table', a 'Field' or an 'Index'. The name of each element comes in the OBJECTNAME column.
I guess GetTables() is an ODBC standard method to retrieve the name of the database's tables ... check your DSN to confirm that the type of database is 'Visual FoxPro Database (.DBC)' and not 'Free table directory'.
That's my two cents, HTH.
Solo se que nada se
Fausto J. Garcia Pino - MCSD.NET
.NET, Oracle, Tronador & Fondismo!