救命！！：sql读取dbf出错！！~~！？？

• Question

• 

  

  0

  Sign in to vote

  执行： 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".

  请问怎会怎会这样？！怎样解决？？

  Friday, August 6, 2010 3:35 AM