Querying a FoxPro DBC with VB.Net

[Guest]

I have been looking all over for the answer to this question. The closest I
have come is reading the knowledge base article number 249718 but that is for
a much older version.

Can someone tell me how to query for a list of tables contained in a foxpro
DBC using VB.Net?

I have 90% of the code generated including the connection to the dbc, but I
cannot seem to be successful querying the dbc. I am using OLEDB
(specifically VFPOLEDB) and I can connect great!

TIA...

 

[Cindy Winegarden]

Hi Scott,

Dim o As Object = CreateObject("Adox.catalog")

Dim conn As Object = CreateObject("ADODB.Connection")
conn.Open("Provider=VFPOLEDB.1;Data Source=C:\Program Files\Microsoft Visual
FoxPro 8\Samples\Northwind\northwind.dbc;")

o.ActiveConnection = conn

For Each oT As Object In o.Tables
Console.WriteLine(oT.Name)
Next