Re: Command Timeouts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Toby Herring (therring*_at_*teletrack.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 13:51:45 -0400

Sorry, I meant the CommandTimeout property on the connection. Both the
ADODB.Connection and the ADODB.Command object have a CommandTimeout
property.

The query-timeout setting on the server may also be set to 30 seconds. By
default, it's set to 10 minutes, I think, but it may have been adjusted by
an administrator. 

-- 
Toby Herring
MCDBA, MCSD, MCP+SB
Need a Second Life? 
http://secondlife.com/ss/?u=03e0e5b303c234bf08e80ee40119a65e
"Charles Dana" <ctdana@slmpd.org> wrote in message 
news:ejcpFLwqEHA.708@tk2msftngp13.phx.gbl...
>
> Yes - I set the connection time to 500 seconds.
>
> Also, if I set the commandtimeout to something like 3 seconds, the job
> still runs for 30 seconds before time out.

Relevant Pages

  • Re: SQL Timeout Error
    ... and how do I set the CommandTimeout property? ... If the connection was established, you may need to set the CommandTimeout ... error message: timeout expired. ...
    (microsoft.public.sqlserver.server)
  • Re: Timeout expired - solve via ConnectionString?
    ... timeout from the connection string, ... >> ConnectionTimeOut!= CommandTimeout. ... you cannot modify commandtimeout using connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: command time out error
    ... I've never tried to set the commandTimeout in the connection string. ... vs. a script timeout? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • RE: How to provide a CommandTimeout at the Connection level.
    ... flexability of specifying different timeout values for different SQL ... How to provide a CommandTimeout at the Connection level. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Using this ADO structure is there a way to access the "CommandTimeout" property?
    ... the Open method of ADO recordset But in your case you are using connection ... Another way is to use Execute method of ADO Command to open recordset. ... this case you would need to set CommandTimeout property of the Command ...
    (microsoft.public.data.ado)