473,473 Members | 2,310 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

SQL Server Timeouts

What could the possible reason be for obtaining "timeouts" when executing a
stored procedure from my application? If I execute the specific stored
procedure in Query Analyzer I do not get any timeouts and the stored
procedure takes approximately 30 to 40 seconds to execute.
Jan 30 '07 #1
2 1244

the default commandtimeout is 30 seconds.

you need to adjust it.

CommandTimeout

...

NOTE
Connection Timeout is NOT the same thing as Command Timeout.


"Connull" <Co*****@discussions.microsoft.comwrote in message
news:E8**********************************@microsof t.com...
What could the possible reason be for obtaining "timeouts" when executing
a
stored procedure from my application? If I execute the specific stored
procedure in Query Analyzer I do not get any timeouts and the stored
procedure takes approximately 30 to 40 seconds to execute.

Jan 30 '07 #2
Thanks for the info. Can I set the Command Timeout if I am using a
Dataprovider?

"sloan" wrote:
>
the default commandtimeout is 30 seconds.

you need to adjust it.

CommandTimeout

...

NOTE
Connection Timeout is NOT the same thing as Command Timeout.


"Connull" <Co*****@discussions.microsoft.comwrote in message
news:E8**********************************@microsof t.com...
What could the possible reason be for obtaining "timeouts" when executing
a
stored procedure from my application? If I execute the specific stored
procedure in Query Analyzer I do not get any timeouts and the stored
procedure takes approximately 30 to 40 seconds to execute.


Jan 31 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: David Gamble | last post by:
I am having problems with long timeouts when connecting to or executing commands in SQL Server 2000 SP3. I am writing an application that will be used on laptops within an environment that is...
10
by: HB Kim | last post by:
Hello, What could possibly cause data in the SQL server database to be removed, except being deleted manually? We had a couple of situations where data in certain records disappeared although the...
4
by: ralphm1 | last post by:
Hello, I am running SQL Server 2000 standard in mixed mode security and have two problems. 1.) I created a database as sa and assigned a login as db_owner, however, the design view is grayed...
5
by: wamatt | last post by:
Subject: SQL server job timeouts? We have a job that uses WinHTTP inside a stored procedure. We have another SP wrapper that runs this for a couple hundred records. When we add this as a job...
2
by: mircu | last post by:
Hi, I need a quick solution to make my application behave correctly when one of these timeouts occurs. I have some logic in session_start but when the authentication cookie timeouts the user is...
2
by: Bernie Yaeger | last post by:
I'm getting the following error - not always, only randomly - when I run a certain routine (the routine is a simple executenonquery and it appears to complete despite the message) against sql...
9
by: craig.overton | last post by:
All, I am currently developing an FTP class in VB.NET. It's kid tested, mother approved when trying to access an FTP Server on a Windows box meaning I can connect, run commands, upload and...
1
by: Mike Hofer | last post by:
I really need some help, and I'd appreciate any that you folks can provide. The ASP.NET application in question uses version 1.1 of the .NET Framework. All of the pages use a common base class...
2
by: webdevaccount | last post by:
Hello, I am using a Timer and an UpdatePanel control. The Timer is set to 1000 milliseconds, and therefore results in many server request timeouts error (logical). The Server Request Timeout...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.