what is this error meaning for?

[NinjaTurtle]

Microsoft OLE DB Provider for SQL Server (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.


this error only occured randomly....

[Roelf]

sounds to me like a transaction which is rolled back, cause one of the statements in the transaction could not be performed.
Transactions could fail for numerous reasons, fe. one of the steps tries to update some records, and one of them is locked during the transaction. If one step of the transaction could not be executed, the whole transaction is rolled back (No work was done). The randomness of occurring is in the number of steps which is performed in a transaction and in the chance of failing a step

[whammy]

What kind of SQL statement are you using?

[NinjaTurtle]

SQL Server 2000 , Windows NT.

[Morgoth]

Randomly eh?

It seems like it's updating nothing, or something like that (from the naked eye.)

Try something, let the code run again, but put in a value that will always change, like a random number or the data/time.