MS SQL

MS SQL RSS

Can return a Stored Procedure Recordset

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2005

Posts: 239

Reputation: extofer is an unknown quantity at this point

Solved Threads: 5

extofer

Offline

Posting Whiz in Training

Can return a Stored Procedure Recordset

Jun 15th, 2006

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??

Thanks

Gabriel Villa
software development/ IT support consultant

•

Join Date: Oct 2005

Posts: 521

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: Can return a Stored Procedure Recordset

Jun 17th, 2006

•

Originally Posted by extofer

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??

Thanks

this article on Microsoft's support site may help