Re: Cursor and Stored Procedures Thanks

[Tom Jensen]

Thanks a lot David. Without your help I didn't make it.

I had to set NOCOUNT ON and ANSI_WARNINGS OFF !!

Again thanks a lot, you saved me doing lot af work !!!

Best regards
Tom Jensen
Denmark


"DaveSatz" <davidsatz@yahoo.com> wrote:
>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
>
>