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?
--
Carsten Thomsen
Enterprise Development with Visual Studio .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Oljeg Popovic" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
