I'd like to know if I have to change security settings or something on my SQL Server in order to applications like ASP or VB to return a recordset. When my applications in VB or ASP return a recordset from a VIEW, I have not problems at all, but when I try to return a Stored Procedure I get the following error:
"Operation is not allowed when the object is closed"
BUT, the object is open, It works on views, if I use:
objRS.Open "SELECT * FROM VIEW", Connection
I have no problems, but when I use
objRS.Open "EXECUTE spProc", Connection
I get problems. Is this a SQL Server side problem that I need to configure??