DaveSatz
03-13-2000, 09:56 AM
This sounds like a problem that I have seen solved by setting NOCOUNT ON in
the stored proc.
--
Thanks,
David Satz
Principal Software Engineer
Hyperion Solutions
(using VB6 SP3/MTS/SQL Server 6.5 SP5a)
(Please respond to the newsgroup.)
Tom Jensen <Tomj@sydbank.dk> wrote in message news:38cce0ca@news.devx.com...
>
> Using ADO from Excel97 to query a Stored Procedure on a SQLServer7.0
causes
> the error
>
> "The operation requested by the application is not allowed if the object
> is closed".
>
> if and ONLY if the Stored Procedure contains a cursor !!!
>
> WHY ?
>
> And what to do if I have to query a stored procedure with a cursor in it
> ?
>
> Best regards
> Tom Jensen
> Denmark
the stored proc.
--
Thanks,
David Satz
Principal Software Engineer
Hyperion Solutions
(using VB6 SP3/MTS/SQL Server 6.5 SP5a)
(Please respond to the newsgroup.)
Tom Jensen <Tomj@sydbank.dk> wrote in message news:38cce0ca@news.devx.com...
>
> Using ADO from Excel97 to query a Stored Procedure on a SQLServer7.0
causes
> the error
>
> "The operation requested by the application is not allowed if the object
> is closed".
>
> if and ONLY if the Stored Procedure contains a cursor !!!
>
> WHY ?
>
> And what to do if I have to query a stored procedure with a cursor in it
> ?
>
> Best regards
> Tom Jensen
> Denmark