connect to foxpro v6.0

Is it possible to connect virtual foxpro v6.0?

You can use the Jet Provider to connect to individual DBF files.

http://msdn2.microsoft.com/en-us/library/aa337084.aspx

I have never used the VFP provider to connect to later versions of VFP files or "database containers". However you will probably see the VFP provider available in the list of providers, and you can try it.

-Doug

|||

Hi Brother,

You can use the FoxPro and Visual FoxPro OLE DB data provider, downloadable from http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx . (Jet won't work on VFP tables.)

A typical connection string for "free" tables is "Provider=VFPOLEDB.1;Data Source=C:\Temp;" and then you refer to specific tables in your SQL statements.

If a DBC file is present your connection string should point to it: "...Data Source=C:\Temp\MyDBC.dbc;" and again refer to the specific tables in your SQL Statements. A DBC is a "Database Container" and has metadata and other data objects such as stored procedures.

|||thanks it is worked.