SQL Client Timeout errors

[RSH]

Hi,

I have an application that creates a call to a SQL Server stored proc. The
stored proc can take a while to perform the necessary tasks, in some cases
as long as 12 minutes. I am using the SQLClient in .Net and I am getting
SQL timeout errors at around 30 seconds. I have tried adding
"ConnectionTimeout=720" to the connection string but it appears to have no
effect.

What can I do to keep the connection from timing out during these longer
processes?

Thanks a ton!
Ron

 

[Guest]

RSH,
It's not your connection that's timing out, its your SqlCommand.
Increase the CommandTimeout.

Peter

 

[chanmm]

Try to set it at SQL server side and see.

chanmm

 

[RSH]

Thanks! That did the trick.

Ron

RSH,
It's not your connection that's timing out, its your SqlCommand.
Increase the CommandTimeout.

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com