Re: VBscript Timed out

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

From: rob (rwc1960_at_bellsouth.net)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 08:37:29 -0400

Thanks Dan

I assume a command such as ADOcon.ConnectionTimeout = 60 will work for the
connection as well. Do you know how to return the Connection Timeout value
to a variable in VBscript ? I would like to display it in a message box
for testing purposes.

Rob

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:uH3MKwLXEHA.3476@tk2msftngp13.phx.gbl...
> You can override the 30 second default timeout with the CommandTimeout
> property of the ADO Command object.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "rob" <rwc1960@bellsouth.net> wrote in message
> news:BqLDc.1121$1D2.1085@bignews5.bellsouth.net...
> > I have a dts package that contains a portion of VB script... every now
and
> > then I get a timed out error message... any ideas ? Any way to
increase
> > the time out within the vbscript ?
> >
> >
> >
>
>

Relevant Pages

  • Re: BCP command where the arguments have a special char
    ... >>> Try queryout like the example below. ... >> Dan Guzman ... >> SQL Server MVP ... the command gives a syntax error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Save as in SQL Server(Backup - Restore)
    ... "Dan Guzman" wrote in message ... > SQL Server MVP ... I take it you already know about the RESTORE command ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Job owned by a non-sysadmin fails to run
    ... Looks like I have a problem with CmdExec jobs in general. ... I changed the step command to "dir c:\temp" and it ran fine when owned by an ... Dan Guzman ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Connection Timeout
    ... Connection timeout has nothing to do with how long the command takes to ... If you are in fact getting connection timeout errors, ... When I try to execute ...
    (microsoft.public.dotnet.framework.adonet)
  • Timeout
    ... I have a GridView that uses a SqlDataSource.Select command to fill with data. ... The user can specify a date range for the select statement and when the ... I have tried increasing the Connection Timeout in the Connection String, ...
    (microsoft.public.sqlserver.clients)