Is it necessary to have timeout value set for the connection string?

[Manik Roy]

Hello,

I am new to ASP application. I have a asp-based web
application that uses SQL Server as the backend. I open
connections to the database on every page. I also have one
custom component that is used for user authentication.
This custom component also connects to the database.

Now, in my code I have set oCon.ConnectionTimeout = 0.

I would like to know whether this is good or not.
The problem is that if the database server is down, the
asp pages are not able to connect for obvious reasons. If
the requests come in for sometime, then after sometime we
are unable to access asp pages.

I have a suspicion that the timeout thing has something to
do with it.

Any help would be appreciated.

With regards,
Manik

[Aaron Bertrand - MVP]

I'd set the timeout to 10 seconds.

Also, if the server is down, the conn.open line will generate an error after
the connectionTimeout has passed, and you can trap this with on error resume
next or a custom error page.

Though, I'd probably spend more time worrying about keeping your database up
and running, rather than just dealing with it when it's down.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Manik Roy" <mroy@duplexinfotech.com> wrote in message
news:001801c3d6e0$d9bfa620$a601280a@phx.gbl...

> Hello,
>
> I am new to ASP application. I have a asp-based web
> application that uses SQL Server as the backend. I open
> connections to the database on every page. I also have one
> custom component that is used for user authentication.
> This custom component also connects to the database.
>
> Now, in my code I have set oCon.ConnectionTimeout = 0.
>
> I would like to know whether this is good or not.
> The problem is that if the database server is down, the
> asp pages are not able to connect for obvious reasons. If
> the requests come in for sometime, then after sometime we
> are unable to access asp pages.
>
> I have a suspicion that the timeout thing has something to
> do with it.
>
> Any help would be appreciated.
>
> With regards,
> Manik

[Manik Roy]

Thanks for the quick reply.

But is specifying the timeout useful during the execution of queries
also.
And, should in this case the timeout value depend upon the load on the
web server also?

With Regards,
Manik

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!