471,832 Members | 1,467 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,832 software developers and data experts.

Unwarranted Error?

Hi everyone,
I'm getting the following error:

ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested
name or ordinal.

Now we all know that it means I'm trying to refer to a column that does
not exist in the DB (SQL Server), yet it definitely, absolutely
exists....

The recordset is created by a stored procedure... this column is even
used on other pages in the same application, yet doesn't work on this
particular page?

This site doesn't get this error in the development environment at all,
just when I've pushed it to live.

Even when I view the results of executing this stored procedure in query
analyser, it returns the column and a value!!!

Could there be another cause of this???

Thanks for any suggestions....
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
1 1025
Put SET NOCOUNT ON at the beginning of the stored procedure.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"fruddy" <fr*****@hotmail.com> wrote in message
news:OB**************@TK2MSFTNGP09.phx.gbl...
Hi everyone,
I'm getting the following error:

ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested
name or ordinal.

Now we all know that it means I'm trying to refer to a column that does
not exist in the DB (SQL Server), yet it definitely, absolutely
exists....

The recordset is created by a stored procedure... this column is even
used on other pages in the same application, yet doesn't work on this
particular page?

This site doesn't get this error in the development environment at all,
just when I've pushed it to live.

Even when I view the results of executing this stored procedure in query
analyser, it returns the column and a value!!!

Could there be another cause of this???

Thanks for any suggestions....
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Tony Wright | last post: by
1 post views Thread by Aravind | last post: by
1 post views Thread by yanwan | last post: by
5 posts views Thread by Enos Meroka | last post: by
7 posts views Thread by p | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.