run-time error - 2147217887

This is one strange situation I am facing, in SQL 2005 server-V.B 6.0 combination.

Here rsReport is an ADODB.Recordset and capturing data by sql 2005 connection string of adUseClient as cursor location.

strSql = sql string

rsReport.Open strSQL, Cn, adOpenDynamic, adLockOptimistic

rsReport!EXTRAFOREOS = 0
--at this point it gives the error - run-time error '2147217887(80040e21)
Multiple step opertion generated errors - check each value status
rsReport.Update

But if I use sql 2000 it is working fine..

So please suggest some way to execute it in sql 2005.

thanks & regards,

francoread brett's sticky at the top of this board. need to see sql.sql