ERROR -2147217887(80040E21)

[2314]

Hi,
I am Getting error ERROR -2147217887(80040E21) Multiple step oledb operation generated error check each oledb status value avaliable no work done. This happens when i try to assign a recordset to a recordset for example
on this line

Set rListRs = rs.Execute(sSQL)

I have already installed MDAC 2.8 on this machine but still i am facing the same problem can any one help me out.

 

[jebenson]

In this line:

Set rListRs = rs.Execute(sSQL)

is rs a connection object? If so, has rListRs been instantiated, like this:

Dim rListRs As New Recordset

or

Dim rListRs As Recordset
Set rListRs = New Recordset

Also, what is the SQL command contained in sSQL?

 

[2314]

boss it has been instatiated and the code is working fine on all machines expect for one machine

 

[dilettante]

No reason for New Recordset, it'll just get thrown away anyhow.

rListRs does[i/] need to be declared as a Recordset or generic Object reference of course...

rs can't be a Recordset, an ADO Recordset has no Execute() method.

If rs is actually a Connection or Command object the problem may lie in the SQL string and the operation it is attempting, cursor type issues, etc.

Something is fishy here. What OLEDB Provider are you using?

 

[jadoogar]

This error comes when a field already updated in
an ado control is again updated before the locking is over.
suppose a field
ado_xx.fields("field1").value="your value"
when ado_xx.update is not given and u are again
doing another update on same ado
this error will come
check