Cursor Engine Error : Please help

I'm working in a 3-tier web-based application on ASP-VB-SQL Server platform and getting the following error message from time to time:


Microsoft Cursor Engine error 80040e21


I went thru MSDN online help and changed the 'Named pipe' connection (to the SQL Server machine) to 'TCP/IP' as per their suggestion but of no help.


The error doesn't occur consistently also, sometimes it disappears itself...!


Any help will be appreciated.

hi,

There are several possiblities for this error.
some of them I am listing here !!

1.) When u r trying to update numeric field with string or ("") , in a recordset.
2.) When u r trying to update date field with blank ("") , in a recordset.
3.) If u r passing data size more than size of the field..

I feel this can helpful for u.

good luck !!
venu