Error in Web Service

hello ,

I have a Web service retrive  dataset and some methods  my application connect to Web Service and

 retrive the data From Web Service  But after  5 minutes  the application raise exception and if I call my Web

Service again from internet explorer  it  gives me this Execption

 System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - Shared Memory Provider: )
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParserStateObject.WriteSni()
   at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
   at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
   at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Pharmacy.load_Cites()
   at MedicalServices.Load_Cites()

 

Thanks




Answer this question

Error in Web Service

  • waddies

    Nobody can solve this problem I need help

  • ChristianEhrlicher

    are you using a sql server express database

  • Dongwei

    How many sql connections is your web service making to the sql database What OS/SP is your sql server running on

  • elainel311

    I have 50 methods in web service and all of them deal with database So I have 50 Sqlconnections

    by the way, this web service in my local computer and the application

    thanks



  • Andrew A

    No Sql server 2000 , I have notice something if I end task the aspnet_wp.exe from

    task manger and reconnect to the web service by the application the connection works



  • Error in Web Service