Help: SqlClient.SqlException: Timeout expired

[hb]

Hi,

I got the "System.Data.SqlClient.SqlException: Timeout expired. " error on
my web
application while saving some data.

Would you please tell me how to change the settings in SQL Server 2000 or
IIS to
increase the timeout?

Thank you

hb

 

[Chris Jackson]

You can change the CommandTimeout property of the SqlCommand object.

 

[Mike Moore [MSFT]]

Hi,

This is controlled by the command object's CommandTimeout property. You can
use this to set the time (in seconds) to wait for the command to execute.
The default is 30 seconds.

Dim myCommand As New SqlCommand()
myCommand.CommandTimeout = 60

Does this answer your question?

Thank you, Mike
Microsoft, ASP.NET Support Professional

Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security.

This posting is provided "AS IS", with no warranties, and confers no rights.


--------------------

 

[hb]

Mike,

Thank you for the help!

hb

Hi,

This is controlled by the command object's CommandTimeout property. You can
use this to set the time (in seconds) to wait for the command to execute.
The default is 30 seconds.

Dim myCommand As New SqlCommand()
myCommand.CommandTimeout = 60

Does this answer your question?

Thank you, Mike
Microsoft, ASP.NET Support Professional

Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer's security.

This posting is provided "AS IS", with no warranties, and confers no rights.

--------------------
From: "hb" <[email protected]>
Subject: Help: SqlClient.SqlException: Timeout expired
Date: Wed, 21 Jan 2004 18:42:18 -0500
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: x403446fe.ip.e-nt.net 64.52.70.254
Path:

cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08

phx.gbl!TK2MSFTNGP12.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.dotnet.framework.aspnet:204045
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Hi,

I got the "System.Data.SqlClient.SqlException: Timeout expired. " error on
my web
application while saving some data.

Would you please tell me how to change the settings in SQL Server 2000 or
IIS to
increase the timeout?

Thank you

hb