为了账号安全,请及时绑定邮箱和手机立即绑定

急!!救命:读取dbf出错~~!!???

急!!救命:读取dbf出错~~!!???

叮当猫咪 2018-09-18 05:06:11
执行:Dim strcon As String = ConfigurationManager.ConnectionStrings("SHConsignmentConnectionString").ConnectionString        Dim con As SqlConnection = New SqlConnection(strcon)        con.Open()        Dim cmd As SqlCommand = New SqlCommand()        cmd.Connection = con        cmd.CommandText = "insert into SALESTABLE (INVOICEACCOUNT) select (din_no) from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=D:\hkpos\hkpos','select * from INV.DBF')"        cmd.ExecuteNonQuery()        con.Close()        con.Dispose()出错提示:Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Driver does not support this function".请问怎会这样,解决办法!??!~?路过的高人,请教~
查看完整描述

2 回答

?
胡子哥哥

TA贡献1825条经验 获得超6个赞

文件名称写完整。加上后缀试试

查看完整回答
反对 回复 2018-09-25
  • 2 回答
  • 0 关注
  • 843 浏览

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信