By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,152 Members | 2,159 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,152 IT Pros & Developers. It's quick & easy.

Help: SqlClient.SqlException: Timeout expired

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.