SQL Timeout - ASP / Active Server Pages

Lin Ma

Dear all,

I need run a few large queries for one time only. But I get scripttimeout.
So I set up server.ScriptTimeout value. It works fine.

But for one query, system gives me the following error:

Microsoft OLE DB Provider for SQL Server (0x80040E31)
Timeout expired

No matter how much I increase ScriptTimeout value, I still have the same
error.

Is there a setting for SQL server timeout value?

Thanks,

Lin Ma

Jul 19 '05 #1

Subscribe Post Reply

6595

Richard K Bethell

Script timeout value has no effect on SQL timeout. You have to change the
value of your ADODB.Connection's CommandTimeout property to something long
enough to allow your SQL server to do the work.

R.

"Lin Ma" <a@a.com> wrote in message
news:OD**************@TK2MSFTNGP11.phx.gbl...

Dear all,

I need run a few large queries for one time only. But I get scripttimeout.
So I set up server.ScriptTimeout value. It works fine.

But for one query, system gives me the following error:

Microsoft OLE DB Provider for SQL Server (0x80040E31)
Timeout expired

No matter how much I increase ScriptTimeout value, I still have the same
error.

Is there a setting for SQL server timeout value?

Thanks,

Lin Ma

Jul 19 '05 #2

Similar topics

ASP timeout issue

by: E Sullivan | last post by:

I am having a time out issue when multiple users are accessing the server. This time out does not happen all of the time. My understanding is that the time out value is actually set in two places....

ASP / Active Server Pages

How to set session timeout

by: Geigho | last post by:

Setting session timeout in web.config file does not seem to have any effect. Any explanation or suggestion will be appreciated.

ASP.NET

Session Timeout

by: Greg Decos | last post by:

I am using forms authentication using a FormsAuthenticationTickets set to expire in 30 minutes and the ticket is added to the collection of cookies. I am not sure where the following values are...

ASP.NET

ASPX Page Timeout - Session Timeout

by: DavidS | last post by:

First: There are several ways to confuse one regarding session timeout. (1) web.config - <sessionState timeout="20"> (2) IIS Manager | Internet Information Services | ServerNode | Default Web Site...

ASP.NET

Strange session timeout problem(urgent help needed).

by: jensen bredal | last post by:

Hello, i'm struggling with a somehow badly understood session scenario. I provide acces to my pages based on form authentication using Session cookies. Som of my pages are supposed to be...

ASP.NET

Setting the Session timeout for a specific page.

by: UJ | last post by:

I have a page where the user can upload a video file. As you can guess, this may take a while. Is there a way I can change the session timeout for just this one page? I would also want to change...

ASP.NET

with timeout(...):

by: Nick Craig-Wood | last post by:

Did anyone write a contextmanager implementing a timeout for python2.5? I'd love to be able to write something like with timeout(5.0) as exceeded: some_long_running_stuff() if exceeded:...

Python

How do I change the session timeout?

by: =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= | last post by:

I tried: <sessionState timeout="1"> </sessionState> bounced IIS, and after 1 minute still had a session. ??? -- thanks - dave

ASP.NET

Cannot set timeout with asp.net 1.1 over than 20 minutes

by: Masso | last post by:

Hallo to the group, my question is this: where i have to set timeout in a web application? If i set into sessionState with property Timeout="60", after 20 minutes the session is over. Always...

ASP.NET

Timeout explanation please?

by: JimLad | last post by:

Hi, I've got a very basic asp.net page that accesses a very slow db query and siplays to screen. I'm hitting a timeout aftre about 3.5 to 4.5 minutes - seems to be variable. SQL connection...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware