Exception while executing Stored Procedure

[Ramnadh]

I got the below exception while executing a Stored Procedure from by
using an adapter. It is showing timed out exception. But when i
execute the same Stored Procedure in the database it is retrieving the
results in few milli seconds. I doesn't understand why it was giving
this error. For the same procedure with the other parameters it is
working fine. But in only one case only it was giving this exception.
Do anyone have the same problem. Any help is highly appreciated.


- sqlEx {System.Data.SqlClient.SqlException} System.Data.SqlClient.SqlException
+ System.SystemException {"Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding."} System.SystemException
+ _errors {System.Data.SqlClient.SqlErrorCollection} System.Data.SqlClient.SqlErrorCollection
Class 10 byte
+ Errors {System.Data.SqlClient.SqlErrorCollection} System.Data.SqlClient.SqlErrorCollection
LineNumber 0 int
Message "Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding." string
Number -2 int
Procedure "ConnectionRead (recv())." string
Server "" string
Source ".Net SqlClient Data Provider" string
State 0 byte

Thanx in advance

 

[W.G. Ryan eMVP]

Remember that there are two types of Timeouts that come into play w/ data
access scenarios - Commamd Timeouts and Connection Timeouts.

Have you run this through Profiler yet? That's probably a good place to
start. Verify that you can open the connection manually beforehand, you
have the necesary privileges etc.