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

[Peter Bromberg [C# MVP]]

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


"RSH" wrote:

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

[chanmm]

Try to set it at SQL server side and see.

chanmm

"RSH" <wa*************@yahoo.com> wrote in message
news:O0**************@TK2MSFTNGP02.phx.gbl...

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

[RSH]

Thanks! That did the trick.

Ron

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:04**********************************@microsof t.com...

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


"RSH" wrote:

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