2. ASPRunnerPro General questions
  3. Microsoft Cursor Engine error '80040e21'
This topic is locked

Microsoft Cursor Engine error '80040e21'

 		10/26/2005 10:01:21 AM
ASPRunnerPro General questions
orit author

I get the error when I try to add or edit record:
Microsoft Cursor Engine error '80040e21'
Multiple-step operation generated errors. Check each status value.
/Marketing/Applications/AIR/Comments_edit.asp, line 114
In my case, in difference from the other questions posted about this error, I get the error each time when I try to save my update, unless I reselect the date (I placed as a default date now()) so if I click on the date picker and select a date, The save action pass successfully - if not, I get this error.
How to fix that?
Thanks
Sergey Kornilov admin 10/26/2005

Now() function displays current datetime according to regional settings on the Web server.
Here is the typical output: 10/26/2005 11:04:14 AM
As far as I understand uour database cannot recognize default date format. Try to use the following as default value:

year(now()) & "-" & month(now()) & "-" & day(now())
orit author 11/7/2005

Perfect, Thanks much
orit author 11/8/2005

I ran the same project on another server and I get the error again:
Microsoft Cursor Engine error '80040e21'
Multiple-step operation generated errors. Check each status value.
/upload/Marketing/applications/air/Comments_add.asp, line 259
but now, nothing help: the default date is already defined as:

year(now()) & "-" & month(now()) & "-" & day(now())



and even if I reselect the date - it doesn't work
What can be the reason? How can I fix that?
Thanks