Unspecified error: E_FAIL(0x80004005)

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I apologize for the duplicate post in Data Access NG.

I get Unspecified error: E_FAIL(0x80004005) when trying
to update Deleted and Modified Dataset records using the
OleDB Command Builder. I have been successful with insert
objects. The target database is DB2/400 with Client
Access v5r2. Here is the partial code:

dr = dsAs400.Tables("RSSC").Select("SCID = " & ScId)
''Resulting array length = 1
dr(0)("NAME") = "TEST"

cnAs400.Open()
Try
Dim cmdBuilder As New OleDbCommandBuilder(daRssc)
daRssc.UpdateCommand = cmdBuilder.GetUpdateCommand
daRssc.Update(dsAs400, "RSSC")
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
cnAs400.Close()

Thanks for any help.
 
Back
Top