Exception: Timeout expired

  • Thread starter Thread starter Dean Slindee
  • Start date Start date
D

Dean Slindee

"The timeout period elapsed prior to completion of the operation or the
server is not responding".
ExceptionType: System.Data.SqlClient.SqlException
Method: OnError

I am getting the above error message when calling a long running stored
procedure from a VS2005 WinForm application. Using Windows 2000 OS with SQL
Server 2000, ADO.NET, Framework 2.0. The stored procedure just takes some
time to build a lot of tables in SQL Server. To be a little more precise,
the one stored procedure calls four more stored procedures (doubt it
matters, but just in case...)

So, my question is this: is there a setting in VS2005 or SQL Server that I
can turn off or extend so that this timeout is disabled?

Thanks in advance.
Dean Slindee
 
Set the CommandTimeOut property of the SqlCommand object to whatever you
need.
 
The standard time out is 20 seconds , so you need to high up the command
time out to the required value

regards

Michel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crystal Report with Stored Procedure 1
Help - why does SqlException not list Procedure name on timeout? 1
What are the steps to fix damaged MDF files in SQL Server? 0
SQL Server Timeouts 2
Timeout expired. The timeout period elapsed prior to completion ofthe operation or the server is no 12
SQL exception timeout 6
Problem in setting Timeout 1
Stored Procedure runs in SQL Server Management Studio but not in VB 1

Back
Top