Re: "Timeout expired. " when using Fill Method

From: Rajesh Gutta (raj_45040_at_yahoo.com)
Date: 06/29/04 

Date: 29 Jun 2004 08:14:36 -0700

I had the same problem, couple of weeks back. I was getting this error
when I tried to execute an stored proc which took 94 sec to complete.
I have changed these three settings and it started working fine..

Commandtimeout = 120 sec
connectiontimeout = 120 sec
Go to the virtual directory and changes the ASP script timeout to 120
sec

Keep in mind the time specified could be different in your case.

Rajesh Gutta

Relevant Pages

  • Re: AI Mind - FORTH
    ... By accident I found a novel thing occuring with my AI Mind. ... execute its own code, for that matter rewrite existing modules as ... I just went in and reentered the test1: ... Since my parser is able to identify adjectives, pronouns, adverbs, ...
    (comp.lang.forth)
  • executing sproc
    ... establish a new Connection Cnct and open it successfully. ... Before I run the stored proc, I execute a SQL Select ... Dim lcsConnectionString As String ...
    (microsoft.public.data.ado)
  • AI Mind - FORTH
    ... By accident I found a novel thing occuring with my AI Mind. ... execute its own code, for that matter rewrite existing modules as ... I just went in and reentered the test1: ...
    (comp.lang.forth)
  • Re: OT: The Huyton axe murder made CNNs Headline News in America...
    ... Yes it would be a risk to execute people like the birmingham lads who were ... "A lot of football success is in the mind. ... had the best two teams on Merseyside, Liverpool and Liverpool Reserves." ...
    (uk.sport.football.clubs.liverpool)
  • Re: Optimizer chooses different plans
    ... All our Employee data is from the mainframe, but the mileage_rate table has no mainframe dependency. ... Anyway, still doesn't answer why the code ALWAYS uses the indexes when cut and pasted to QA, but not so when the stored proc is executed. ... > Analyzer and execute it, ... >> After we added the hints it worked for a while but now does table scans. ...
    (microsoft.public.sqlserver.server)