Weird problem with ASP, SP and Linked Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Weird problem with ASP, SP and Linked Server

Author

Topic

zeroth
Starting Member

3 Posts

Posted - 2004-09-15 : 08:10:06

Hi I've got a really weird problem involving ASP, Stored Procedures and a Linked Server.

I'm calling a stored procedure which calls itself on the linked server. If I call this stored procedure from Query Analyzer it works just fine. But if I call it from within a ASP page I get this:

error 'ASP 0113'
Script timed out

There is NO reason for it to time out. Called from the Query Analyzer it takes 200 ms.
I use the same login in Query Analyzer as in ASP so it's not a permission problem.

If I uncomment the line which call the sp on the linked server it works.

This thread explains the same problem:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=%23UorgLOaDHA.3444%40tk2msftngp13.phx.gbl&rnum=2&prev=/groups%3Fq%3D%2522stored%2Bprocedure%2522%2Basp%2B%2522linked%2Bserver%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3D%2523UorgLOaDHA.3444%2540tk2msftngp13.phx.gbl%26rnum%3D2

But there's no solution :(

Thomas Andersson
Intersolia Sweden AB
http://www.intersolia.com

steelkilt
Constraint Violating Yak Guru

255 Posts

Posted - 2004-09-15 : 15:08:16

have you checked your script timeout setting within IIS to make sure it's not set for a "quick" timeout?

Is IIS on a different box than SQL Server?

zeroth
Starting Member

3 Posts

Posted - 2004-09-16 : 03:20:27

It takes about 1-2 min for it to time out, so it's certainly not a "quick" timeout. The IIS is on the same box as the 1st SQL Server.

Thomas Andersson
Intersolia Sweden AB
http://www.intersolia.com

zeroth
Starting Member

3 Posts

Posted - 2004-09-17 : 05:16:20

The stored procedure call _does_ work from VB so I guess I'll have to wrap the stored procedure call in a component and call it from ASP that way. But I'd rather have a solution or at least an explanation for the weird behaviour.

Thomas Andersson
Intersolia Sweden AB
http://www.intersolia.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources