Re: timeout

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 22:42:14 +0100

In your VBScript file you have to increase the default timeout (30 seconds)
to more than a minute. You have to change the CommandTimeout property of
your command/connection object. the Query timeout value in Enterprise
Manager, is for Enterprise Manager and is not relavant when running your
VBScript. You might want to have a look at the following articles:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Rob" <anonymous@discussions.microsoft.com> wrote in message
news:274f901c462c5$9573cc50$a301280a@phx.gbl...
> Hello All,
>
> I have a vb script that verifies if a specific service is
> running, if yes, then it runs a sql stored proc.
> The stored proc takes about 1 minute to run when launched
> from QA.
> However, when launched through the vbscript file, I get a
> Timeout Expired from MS OLE DB Provider for SQL Server
> error.
> Query-timeout in Enterprise is set to 0.
>
> I can post a script if needed, but, doesn't seem to be a
> syntax problem.
> Any thoughts are appreciated,
> R
>

Relevant Pages

  • Re: timeout
    ... the Query timeout value ... >> running, if yes, then it runs a sql stored proc. ... >> However, when launched through the vbscript file, I ... >> Timeout Expired from MS OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.server)
  • RE: Timeout Expired for no apparent reason
    ... I will set the CommandTimeout property and see what it does. ... > It is correct that if you are using OLE DB directly the default timeout is ... > and not the duration of the transaction. ... > This apply to MS SQL Server. ...
    (microsoft.public.data.oledb)
  • Re: Query Timeout Expired Using SELECT/WHERE
    ... Set the CommandTimeout property of the SelectCommand property of the ... I am using C# to a SQL Server 2005 database using an SqlDataAdapter, ... The timeout period elapsed prior to completion of the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: timeout expired problem
    ... time and provider generates timeout error. ... the connection and Command. ...
    (microsoft.public.vb.database.ado)
  • Re: CommandTimeOut Problem
    ... There was an issue IIRC with the CommandTimeout property in the 1.0 version ... of the Framework that was fixed in 1.1. ... scrolling techniques that are a lot more efficient and far less demanding on ... you can set the timeout to a very large number (as ...
    (microsoft.public.dotnet.framework.adonet)