/////Odbc
////VFPODBC: Microsoft Visual FoxPro Driver
///下载的VFPODBC驱动在win7上安装后都不能成功 ,可能是太老了太久无更新了
//using System.Data.Odbc;
//OdbcConnection conn = conn = new OdbcConnection();
// ODBC DSN
//conn.ConnectionString = "Dsn=DsnName";
// ODBC without DSN -- Database container (dbc)
//conn.ConnectionString =
// "Driver={Microsoft Visual FoxPro Driver};" +
// "SourceType=DBC;" +
// "SourceDB=C:/MyPath/MyDb.dbc;" +
// "Exclusive=No";
//// ODBC without DSN -- Free table directory
//conn.ConnectionString =
// "Driver={Microsoft Visual FoxPro Driver};" +
// "SourceType=DBF;" +
// "SourceDB=C:/MyPath;" +
// "Exclusive=No";
//通过 Microsoft dBASE Driver 访问
// conn.ConnectionString ="Driver={Microsoft dBASE Driver (*.dbf)}; SourceType=DBF;Data Source=" + dbfpath + ";Exclusive=No; NULL=NO;Collate=Machine; BACKGROUNDFETCH=NO; DELETE=NO";
//conn.Open();
/////////////OleDb
////VPFOLEDB: Microsoft OLE DB Provider for Visual FoxPro 9.0
///VPFOLEDB的官方下载地址:https://www.microsoft.com/en-us/download/details.aspx?id=14839
///测试 win7 可以安装成功
OleDbConnection oledbcon = new OleDbConnection();
////OleDb-- Database container (dbc)
oledbcon.ConnectionString =// dbfConstr(dbfpath, 3);
"Provider=VFPOLEDB;" +
"Data Source=" + dbfpath +
";Collating Sequence=machine;" +
"Password=Secret;";