Re: Help: inappropriate OLEDB timeout:

"Matt C." <canimal@xxxxxxxxxxx> wrote in
news:Xns968BAE6E45433canimalmydejacom@xxxxxxxxxxxxx:

> Erland Sommarskog <esquel@xxxxxxxxxxxxx> wrote in
> news:Xns968BE49E853C9Yazorman@xxxxxxxxx:
>
>> Matt C. (canimal@xxxxxxxxxxx) writes:
>>> Starting yesterday, an application that has previously run without
>>> problems (for several weeks now) has started throwing Timeout
>>> Expired errors after 30 seconds.

I believe I've sorted this out. It is a combination of two things: the
MDAC hotfix described in kb article 832483, and setting the
CommandTimeout to a large value ( > 65536).

On PCs that have the hotfix applied, when the CommandTimeout is set to
65537, I get the premature 30 second timeout. When it's set to 65534,
there is no premature timeout and the process completes normally.

Matt
.

Relevant Pages

  • Re: Help: inappropriate OLEDB timeout:
    ... Matt C. writes: ... > MDAC hotfix described in kb article 832483, ... The default timeout of 30 seconds is evil. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: Gratuitous ARP
    ... you think that lowering the= timeout to 5 seconds would be ok? ... cisco device not to ... > solution but security is a concern. ... Matt Douhan ...
    (freebsd-stable)
  • Re: On some Please listen to my demo type ish...
    ... Timeout. ... Matt ... Me: "fat laces" ... Prev by Date: ...
    (rec.music.hip-hop)
  • ? How to set FTP session time limits ?
    ... Are you talking about general session time or timeout? ... my knowledge there is no way to limit session lengths. ... But timeout is a different story. ... Matt ...
    (microsoft.public.inetserver.iis.security)
Quantcast