執(zhí)行: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()出錯(cuò)提示: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".請(qǐng)問(wèn)怎會(huì)這樣,解決辦法!??!~?路過(guò)的高人,請(qǐng)教~
急!!救命:讀取dbf出錯(cuò)~~?。。???
叮當(dāng)貓咪
2018-09-18 05:06:11