Hi Friends

Can anyone tell me how to implement Sql Connection Timeout in web.config file. Thanks

__________________
Regards
Mike

what do you mean my Implementing "Sql Connection Timeout". Do you want to set the timeout for the SessionState stored in SQL Server??

Regards
Ganesh

Hi

I am using SQL Server with my website, but in some cases while searching for member profiles on my website, it gives a message that server timeout or expiration something like that. So I want to increase this time out so that even if sql takes time to retrieve a query, it doesn't show time out.

Thanks

The page is tired of waiting for the SQL server-- this can be changed-- but better to work on your database and figure out why it's operating so slowly.


Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.

Hi

I have checked my database but couldn't find any fault, can u please let me know how to use the commandTimeOut property
Thanks

Your going to regret changing the timeout-- your will hose up your server with ASP.NET queues building... I am telling you, your missing an index in your database. Have you tested the Query through the analyzer? Is it doing table scans where you should have an index? Have you run the Index Wizard?

As for SQLConnectionTimeout- that isn't a property of anything.... As I said already- your problem is, most likely, IIS being tired of waiting for the page to process so it aborts it.

The connection timeout itself is part of the SQL Connection String that your using-- However, you need to extend the ASP.NET page timeout also.

Google can help you with the exact syntax.

Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.