VFP的连接ODBC和OLEDB(2018年整理亲测)

/////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;";