A transport-level error when calling SqlCommand.ExecuteNonQuery() -
09-28-2007
, 03:12 PM
I have a stored procedure with some input parameter and one output parameter.
I use SqlCommand and SqlParameter as following
///Set some imput parameters here
parameter = cmd.CreateParameter();
parameter.ParameterName = "OutputParameter";
parameter.DbType = DbType.String;
parameter.Size = 16;
parameter.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parameter);
cmd.ExecuteNonQuery();
However, the last statement generate the following error and the connection
closed because of that:
A transport-level error has occurred when receiving results from the server.
(provider: TCP Provider, error: 0 - The specified network name is no longer
available.)
Any ideas? |