ConnectionCheckForData ???

[Oljeg Popovic]

Hi,





I'm working on a Web Service that is working fine, but sometimes I received
this SqlException.



Error #-2: Timeout expired. The timeout period elapsed prior to completion
of the operation or the server is not responding. on line 0.
Error reported by .Net SqlClient Data Provider while connected to
<SERVERNAME>

Error made in procedure ConnectionCheckForData (CheckforData()).
Sql Server error code: 0



StackTrace: at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
at RCService.Db.ReaderInboxListSP(String userID, String account, DBName
dbName)
at RCService.Util.GetInboxList(String userId, String account)





It hapens while executing sp with simple select statement.

I would appriciate if someone could tell me somethnig more about this error.





Enviroment: SQLServer 2000 SP 3, Windows 2000 Server.



Oljeg

 

[CT]

Well, b y the looks of it, you're experiencing a simple timeout connecting
to or awaiting a response from your db server. Is it located on the same
machine as your web service? Are you calling the web service multiple times?
Does the sp lock any of the data rows?