Error 3265

From: Ben (benmoen_at_DONT_SPAM_MEyahoo.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 07:56:08 -0800

I am attempting to perform a [Connection].Execute(sql string) withn an asp page. I am getting a 3265 - "Item cannot be found in the collection corresponding to the requested name or ordinal."

I have been reading through suggested resolutions at multiple newsgroups (via googlegroups). However, the sql string does NOT contain invalid column names, and the same string will execute in query analyzer (T-SQL) under the same login/authentication. Prior to this call, I am using the same connection object in two instances to execute different stored procs, and using these results to populate arrays. Is this an issue - is this causing a problem with ADO?

Ben