468,284 Members | 1,530 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

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
Nov 18 '05 #1
4 17722
You can change the CommandTimeout property of the SqlCommand object.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"hb" <ho****@goodoffices.com> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...
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

Nov 18 '05 #2
You can change the CommandTimeout property of the SqlCommand object.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"hb" <ho****@goodoffices.com> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...
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

Nov 18 '05 #3
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" <ho****@goodoffices.com>
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: <eV**************@TK2MSFTNGP12.phx.gbl>
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!TK2MSFTN GXA05.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


Nov 18 '05 #4
hb
Mike,

Thank you for the help!

hb
""Mike Moore [MSFT]"" <mi****@online.microsoft.com> wrote in message
news:S2****************@cpmsftngxa07.phx.gbl...
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" <ho****@goodoffices.com>
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: <eV**************@TK2MSFTNGP12.phx.gbl>
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!TK2MSFTN GXA05.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

Nov 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Jason | last post: by
3 posts views Thread by Matt | last post: by
15 posts views Thread by DavidS | last post: by
reply views Thread by almurph | last post: by
1 post views Thread by alvinstraight38 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.