执行: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".请问怎会这样,解决办法!??!~?路过的高人,请教~
添加回答
举报
0/150
提交
取消