Cursor Engine Error : Please help

[Chirantan Kundu]

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.

[Venu Kuamr.B.]

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