|
|
Posted by serge on 07/29/05 04:47
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.
Navigation:
[Reply to this message]
|