Access FoxPro tables from VB .NET

[TonyScarpelli]

I have a number of free FoxPro tables that I need to access from VB .NET. I think I have to use ODBC, but I'm not sure of the syntax.

Anyone do this kind of thing before?

Thanks.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[Black007]

For your first try see the KB article at

http://support.microsoft.com/?id=192979,

"PRB: VFPODBC Driver Ignores Path
in DSN When Executing SQL"

For your second try, the error message says it doesn't like the value you
have entered for SourceType. I'm assuming you used the OLE DB provider for
ODBC drivers. Your SourceType is blank and the driver doesn't have support
for that value. Try SourceType=DBF (or SourceType=DBC if you're connecting
to a dababase).

You can also use the Visual FoxPro OLE DB provider, downloadable from

http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.

A
connection string using the Visual FoxPro OLE DB provider does not have a
SourceType parameter. OLE DB determines from the source whether it's a DBC
or free tables.