未在本地计算机上注册“VFPOLEDB.1” 的解决方案

网上这个问题讨论的比较多,我也遇到了这个问题,结果将目标平台改成x86 就可以正常运行了

这个是读取DBF的代码

private DataTable oledbRead(string dirname, string filename)
        {
     
            string sqlstr = $"select *  from {filename}";

            string strConn = @"Driver={Microsoft Visual FoxPro Driver};Provider=vfpoledb;Data Source=" + dirname + ";Collating Sequence=machine;";
            using (OleDbConnection myConnection = new OleDbConnection(strConn))
            {
                OleDbDataAdapter adpt = new OleDbDataAdapter(sqlstr, myConnection);
                DataSet mySet = new DataSet();

                adpt.Fill(mySet);


                myConnection.Close();
                return mySet.Tables[0];
            }
        }

  

 

posted @ 2018-12-04 17:43  小熊V5  阅读(1317)  评论(0)    收藏  举报