Unuseful ADO error message

[chrisjk]

Can somebody who is fluent in Microsoft's new language "we can't be bothered to write useful error descriptons" translate the following annoying run time error caused by the ADO Update method...

Error Number: -2147217888 (80040e20)
"Provider called a method IRowsetNotify in the consumer and the method has not yet returned."

Thanks!

[Gimpster]

Well, I can tell you that is not a Microsoft message for starters. It is a message from the database you are trying to connect to. It's possible you could have some syntax wrong in your SQL statement or you could be trying to save the wrong kind of datatype to the field, or maybe you forgot to put apostraphies(one of these--> ' ) around the information you were trying to save. I can't tell you any more than that. But rest assured that the problem is coming in in the way that you are trasacting with your database.


Just a note. One way you can find out if an error message is from Microsoft is if it appears in the MSDN files. If the error message does not appear in the MSDN files, then it's not from Microsoft. Microsoft always gives you a description of their error messages in the MSDN files.
------------------
Ryan


[This message has been edited by Gimpster (edited 02-07-2000).]

[chrisjk]

Well it is from Microsoft, as anything that could be causing it to happen is made by them (VB, ADO, Access, Windows...).

I checked out MSDN already using the Help button on the error message. It told me the topic could not be found!. Doubtless it was be gibberish as well.

Thanks anyways

[This message has been edited by chrisjk (edited 02-07-2000).]

[bsmith]

Try this Microsoft search site. This were I found the solutions to many of my ADO error messages. The message you received looks like an ADO message: http://search.microsoft.com/us/SearchMS.asp

[Frans C]

Yep, definitive a microsoft error
And microsoft doesn't understands it themselves yet
For some clues: http://support.microsoft.com/support.../Q195/6/38.ASP

[SergeyT]

It shouldn't be Microsoft Error.
What about provider?
There are some companies - ODBC drivers developers, and drivers returning a lot of stupid messages (for example, one for Sybase 11 I'm using).
You have to Raise errors (depends on driver).
Some of errors are related to Rs.MoveLast, Rs.RecordCount, cursor type etc.

[chrisjk]

Thanks guys...check this out

SYMPTOMS
When manipulating methods of the ADO Data Control's Recordset property through code, or when manipulating an ADO Recordset object that has controls bound to it, you receive the following error message:

Run-time error '-2147217888 (80040e20)':
Provider called a method from IRowsetNotify in the consumer and the
method has not yet returned.

CAUSE
Microsoft is currently investigating the cause of this bug.

[Johnny23]

it is an error from the database ,what are you trying to do?? updating records dor adding new records, this error suggests that
the autonumber that your are trying to add the record has already been taken,
if you run this query from sql server manager it should fix the problem

dbcc checkident (Put name of table in here)