Re: general network error

Maybe it's the SQL statement that is timing out. In how many
seconds approximately do you get the timeout message?


> Getting this error intermittently:
>
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>
>
> After getting a fair number of these errors I get this one also:
>
> System.Data.SqlClient.SqlException: General network error. Check your
> network documentation.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>
>
> SQL connection pooling is turned off. All sql parameters passed to the
> stored procedure and all the data types are correct.


.

Relevant Pages

  • Timeout expired error executing a simple View in SQL Server 2005 Express SP2
    ... and hitting problems executing simple Views executed from SSQL Server ... Next we started to create Views with various filter criteria to assess ... SQL Execution Error. ... The timeout period elapsed prior to ...
    (microsoft.public.sqlserver.connect)
  • Re: best practices to support multi-users
    ... > have a client application installed on several machines which access a sql ... > period it gives an error saying timeout expired. ... and you then interpret the timeout to mean that ... there was contention. ...
    (microsoft.public.vb.database.ado)
  • Re: timeout expired on View
    ... Error Message: Timeout expired. ... SQL Server Driver]Timeout ...
    (microsoft.public.sqlserver.tools)
  • Re: Simple timeout problem
    ... Brian, I haven't found anything specific on this error. ... We'd want to limit the trace to just the BizTalkRuleEngineDB. ... To run a trace go to SQL Profiler (under the SQL Server entry in the start ... | are reporting a timeout condition trying to connect to the SQL database. ...
    (microsoft.public.biztalk.general)
  • Re: Time Out
    ... > The following timeout problem is experienced during inserts. ... > cmdBehavior, RunBehavior runBehavior, Boolean returnStream) ... > at EDITPS.Utilities.SqlHelper.ExecuteNonQuery(SqlConnection connection, ...
    (microsoft.public.sqlserver.server)