Error on stored procedure

[sivabe]

Hai all ,
when am executing my stored procedure am getting the following error

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

can anyone give me the solution
thnx and advance

[Shashi Sadasivan]

Hi,
I have had heaps of problem with this.
Unfortunately what it means is that the query was supposed to take a certain amount of time, but no answer has been received yet.

The only way i could get out of this issue was to turn pooling off. (which can be done at the connection string)

Setting pooling to off will remove this issue altogether(there might be an un-noticably longer wait time with th application which should be easily bearable)

I checked the server logs and the server had its own issues with the netowrk (it even received some results 120 seconds late, this was just a network log, and not related to the application). Still cant really point to what the cause is, but it certainly isint your application.

To be on the safer side, make sure you dispose all your connections and adapters.