Accessing Foxpro DBF and index files

[Guest]

Please give me example to connect to DBF files and its indexes using OLEDB.NET
Thank you.

 

[Hirantha]

try

string sConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\dbf;Extended Properties=dBase III";
OleDbConnection oCn = new OleDbConnection(sConnection);
OleDbCommand oCmd = oCn.CreateCommand();
oCmd.CommandType = CommandType.Text;
oCmd.CommandText = "SELECT * FROM authors.dbf";
OleDbDataReader oRd = oCmd.ExecuteReader();

 

[Cindy Winegarden]

In news: (e-mail address removed),

Please give me example to connect to DBF files and its indexes using
OLEDB.NET. Thank you.

Hi Ma,

Do you have the latest VFP OLE DB data provider, available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx ?

If the index files are CDX files (you will see CDX files that match their
corresponding DBFs) they will be updated automatically. If they're IDX files
then all I can say is that I haven't found a way to update these older-style
indexes.