dotnet datatools: Time out issue within .Net when calling multiple stored procedures -- dotnet datatools

Time out issue within .Net when calling multiple stored procedures

robin9876 NO[at]SPAM hotmail.com
1/11/2007 8:54:42 AM

dotnet datatools:

In .Net v1.1 I am calling 4 stored procedures in a single execute
reader statement which is timing out after 30 seconds. However the same
SQL statement can be run in SQL 2005 Management Studio as the same user
in under 1 second.
This has worked in the same code to another set of 4 stored procedures
on the same server.

Has anybody got any ideas/suggestions on what is causing this or how to
resolve it?

Re: Time out issue within .Net when calling multiple stored procedures

Mary Chipman [MSFT]
1/11/2007 1:05:27 PM

Have you tried creating a stored procedure that calls the set of 4
stored procedures then calling that stored procedure from your reader?

--Mary

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the dotnet datatools group.