Post reply

Parameter to tweak to allow for greater tolerance for TIME-OUTS??

  • January 23, 2004 at 12:30 am

    #85438

    Hi! Is there a parameter in SQLServer that we can set to allow for greater tolerance for time-outs? I believe we have the "login time-out" setting. But are there any?

  • January 23, 2004 at 8:11 am

    #491378

    If you mean a connection is timing out, that's set on the client side, not the server side.



    --Jonathan

  • January 25, 2004 at 6:45 pm

    #491554

    How do we do that on the client side? Add/set a parameter in the program (e.g. TSQL, VB script,etc)?

  • January 26, 2004 at 5:58 am

    #491582

    Yes, if you mean your queries are timing out, then use the Timeout property of the command object.  If you set this to 0 (the default in Query Analyzer), there will be no timeout.  The usual default for ADO is 30 seconds.

    If you mean the connection itself is timing out, that's the Timeout property of the connection object.  The default is 60 seconds.



    --Jonathan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply