I am starting a new thread on this topic because I have seen this work,
in fact I MADE it work. Quite by accident apparently...
I have been running IIS3.0, NT4, and SQL6.5 (sp3) using active server
page's ADO interface to deliver content from a database. I had it
working for one year without ever experiencing difficulties.
Now recently, I installed a new server and ported my asp's and database
over to the new machine, and I got the infamous error:
Cannot open a cursor on a stored procedure that has anything other than
a single select statement in it.
I had never gotten that before so the problem cannot be with my code. I
am running the same version software - so in my mind the problem has to
be on the configuration end. The MS Knowledge Base tells me what I have
read in this newsgroup: that a cursor has to be read only and forward
only. Surely there is a way to specify that as a default without having
to rewrite any of my code... right? I mean I had the damn thing working!
I am at the end of my rope. Comments please.