C# .NET - error while exec stored procedure
Asked By sivakumar subramaniam on 13-Sep-08 02:43 AM
i have exec the stored procedure am getting timeout expired error.
but i added the sqlcmd.Commantimeout=120;
even am getting the same problem..
can any one me the solution
thnks and advance
Error while exec stored proc
Shailendrasinh Parmar replied to sivakumar subramaniam on 13-Sep-08 02:49 AM
The default timeout is 30s... You may try:
1. Plus "Timeout=XX" in your connection string, where XX is seconds
2. Set both Connection.ConnectionTimeout and Command.ConnectionTimeout
Hope this helps.
error while exec stored procedure
Sagar P replied to sivakumar subramaniam on 13-Sep-08 03:05 AM
You need to set the "CommandTimeout" parameter before you open the connection.
Lock_TimeOut in the remote stored procedure.
SET LOCK_TIMEOUT 3000 --3 seconds
May be this will solve your error.
sivakumar subramaniam replied to Sagar P on 13-Sep-08 03:25 AM
Now is working properly...
Getting timeout expired
Binny ch replied to sivakumar subramaniam on 13-Sep-08 04:36 AM
1) You can not set ConnectionTimeout in code, it mus be done in the connection string (Connect Timeout =30).
2) To modify the command timeout set the CommandTimeout property:
SqlCommand command = new SqlCommand ("myLoadProc", myConnection);
command.CommandTimeout = 180; //3 minutes
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@param1", this.Param ) );
adapter.SelectCommand = command;
adapter.Fill( ds );
3) It seems, from the writings, that is a good idea to reset the colmmand timeout after finishing the command to the default . . .
Perry replied to sivakumar subramaniam on 14-Sep-08 04:13 AM
just set the command timeout parameter before you open any connection by using SQL command like SqlCommand command = new SqlCommand (); and set
command.CommandTimeout = 180; and other variables like load profiles and connections to the server. This will solve your problem.