DB Connection Timeout

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Badri - 04 Apr 2005 19:05 GMT

I am having a long running stored procedure and I'd like my C# code to wait
longer before it timesout. So I use the following connection string but still
it always timesout after about 40 secs.
"Server=" + ServerName + ";Database=" + Database + ";Integrated
Security=SSPI;Connect Timeout=600"

What am I doing wrong?

Reply to this Message

gaidar - 04 Apr 2005 19:38 GMT

Check your database server settings. Is it allow setting timeouts more than
40 second?

If the problem is not on client than it's obviously on the server :)

Gaidar

>I am having a long running stored procedure and I'd like my C# code to wait
> longer before it timesout. So I use the following connection string but
[quoted text clipped - 4 lines]
>
> What am I doing wrong?

Reply to this Message

Badri - 05 Apr 2005 11:31 GMT

Thx for your response, Gaidar. I checked in my Enterprise Manager by
right-cliking on the servername. I found a tab called "Connection" wherein
there was an option for "Query time-out"; it is already set to 600 secs. Is
there are different place that I need to change as well.

> Check your database server settings. Is it allow setting timeouts more than
> 40 second?
[quoted text clipped - 11 lines]
> >
> > What am I doing wrong?

Reply to this Message

DB Connection Timeout

Free Magazines