Problem returning data with a stored procedure

[Wayne]

I have an ASP calling a stored procedure to return a recordset. The stored
procedure quires
another server for part of the data being returned (using linked MS SQL 7
servers). The stored
procedure runs fine from with query analyzer, but I get this when calling
from within the
ASP page:

error 'ASP 0113'
Script timed out

If I comment out the lines in the stored procedure, it runs fine from within
ASP then. So I'm
thinking it must be some type of permission issue. Any ideas??

Thanks

[John Beschler]

Have you made sure the the user your ASP pages are running
under has an account on the linked SQL server and that it
is able to authenticate to that server.

To test it: create a simple SP on the linked server and a
simple ASP page to call that ASP directly from the linked
server. If this works, I would think that the sp with the
linked query should work.
HTH,
John

>-----Original Message-----
>I don't think it is timing out from the stored procedure.

The stored

>procedure
>runs in about 2 to 3 seconds. I can drop the stored

procedure into a VB

>app and it runs fine. The ASP page still doesn't work and

I get a timeout

>error.
>
>I'll try increasing the timeout settings though....
>
>"John Beschler" <giles@geewhiz.com> wrote in message
>news:029a01c3681f$b4bc4ca0$a501280a@phx.gbl...

>> Why would the message "script Timeout" lead yo to

believe

>> it's a permissions issue?
>>
>> In any case, that error means that the web server was
>> waiting for the script (ASP) to finish running and

return

>> it's results to the ASP dll. It did not do that in the
>> alloted time so the browser issued that error message.

The

>> quick, but not the best approach, is to extend the

alloted

>> time that scripts are allowed to run. The correct fix,

is

>> to determine why your stored procedure takes so long to
>> run and then fix that.
>>
>> To extend the timeout for scripts you can either change
>> the setting in the web server or add the ScriptTimeout
>> Property of the Server object to your page.
>>
>> For example:
>> Server.ScriptTimeout = 240
>> set the timeout to 240 seconds.
>>
>> HTH,
>> John
>>
>>
>>
>>

>> >-----Original Message-----
>> >I have an ASP calling a stored procedure to return a

>> recordset. The stored

>> >procedure quires
>> >another server for part of the data being returned

(using

>> linked MS SQL 7

>> >servers). The stored
>> >procedure runs fine from with query analyzer, but I get

>> this when calling

>> >from within the
>> >ASP page:
>> >
>> >error 'ASP 0113'
>> >Script timed out
>> >
>> >If I comment out the lines in the stored procedure, it

>> runs fine from within

>> >ASP then. So I'm
>> >thinking it must be some type of permission issue. Any

>> ideas??

>> >
>> >Thanks
>> >
>> >
>> >.
>> >

>
>
>.
>