This thread also displays on the following board(s):
Calgary  &  Saskatoon  &  Vancouver

Topic: Message Board administrator

Author: .Garry Original Message Posted: Jan 4 2010 3:20PM

Hopefully someone knows why the following happens whenever I make a post...An error message pops up with the following...

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/StoreMessage.asp, line 291

It still makes the post though????


Author: hardboiled Reply #1 Posted: Jan 4 2010 5:22PM

Y2-Ten




Author: Aged Whine & Cheese Reply #2 Posted: Jan 5 2010 1:53AM

Well Garry, the reason that is happening is that when the ADODB Recordset is saved, the item cannot be found in the collection corresponding to the requested name or ordinal. Fortunately, this is happening at line 291 of /StoreMessage.asp.

Glad to be of help.



Author: Table Lag Reply #3 Posted: Jan 6 2010 12:42AM

Tim, I know you're trying to help, and that's the important thing here. But you neglected to point out what I think is crucial to resolving this issue: specifically, it's an 800a0cc1 error.


Author: Table Lag Reply #4 Posted: Jan 6 2010 12:47AM

I'm certain that Barry should SET NOCOUNT ON at the top of the procedure. I'm Feeling Lucky.


Author: Aged Whine & Cheese Reply #5 Posted: Jan 6 2010 1:24AM

Is NOCOUNT kind of like what my Mom yells at me?

"You NOCOUNT loser - why did I waste time rearing you!!!!"

For a SQL operation, it sure does bring back memories.


Author: The Devil Reply #6 Posted: Jan 6 2010 1:02PM

This thread is for nerds.


Author: Aged Whine & Cheese Reply #7 Posted: Jan 7 2010 12:51PM

Hey Jeffy, don't condemn an entire thread just because Richard posted on it.


Author: Barry Reply #8 Posted: Feb 2 2010 9:39AM

I'm on it guys.... sorry I didn't notice this earlier.


Author: Aged Whine & Cheese Reply #9 Posted: Feb 2 2010 5:59PM

Cool, I just posted without an 800a0cc1 error!!!!


Author: Table Lag Reply #10 Posted: Feb 8 2010 1:31AM

Hey Barry was it NOCOUNT? Was it? Was it? [Circles madly about like Chester the Terrier]


This thread does not accept replies because:

The last post to this thread is more than 999 days old.