Connection Timeout Expired

[Benniit]

Please, am using vb.net 2008 and sql server 2008. I have a search form and when i search at times, I have "Connection Timeout Expired" error.

I dispose and close the connection after establishment, but i still get it.

I tried setting MyConObj.ConnectionTimeout = 0 and it also gives me "Property ConnectionTimeout is ReadOnly.

What should I do now? Please help me out.


Ben.

[pankajvtcse]

@Benniit
IF you are creating WEB application then in web.config <Connection> you can increase the time out property value.

Or better is that : I think you have a lots of data in your table,So you should increase the filter criteria from UI,so you will search less data,which required less time.

One more thing the Query/Procedure you have create to Search need to more OPTIMIZED use less JOINS.

And create indexes in your tables to increase the speed to search.

Hope this will help you.

Happy QUERY..
-Pankaj Tambe.