.NET Data Adapter Timeout SP Issue
Posted
by A-B
on Stack Overflow
See other posts from Stack Overflow
or by A-B
Published on 2009-05-28T13:23:35Z
Indexed on
2010/05/05
3:08 UTC
Read the original article
Hit count: 309
We have a SQL Server stored procedure that runs fine in SQL Manager directly, does a rather large calculation but only takes 50-10 seconds max to run.
However when we call this from the .NET app via a data adapter it times out. The timeout however happens before the timeout period should, we set it to 60 seconds and it still times out in about 20 seconds or less.
I've Googled the issue and seen others note issues where a SP works fien directly but is slow via a data adpater call.
Any ideas on how to resolve this?
© Stack Overflow or respective owner