Re: Help: inappropriate OLEDB timeout:

Matt C. (canimal@xxxxxxxxxxx) writes:
> 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.

The default timeout of 30 seconds is evil. I wonder how much grief
and money it costs all over the planet?

In theory at least, a timeout of 0, should give you an inifinite timeout,
but I seem to recall reports of ADO not always respecting this.

The funny thing is that if you program against the OLE DB API directly,
the default for the timeout in SQLOLEDB is 0.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

Relevant Pages

  • Re: Help: inappropriate OLEDB timeout:
    ... >> Matt C. writes: ... MDAC hotfix described in kb article 832483, ... I get the premature 30 second timeout. ... there is no premature timeout and the process completes normally. ...
    (microsoft.public.data.oledb)
  • Re: Check Linked Table Connection
    ... That will only test to make sure the connection is available. ... Run the query with a 20 second timeout. ... but I don't have any direct access to their SQL Server nor their ... I am an outside programmer that end-users contract, ...
    (comp.databases.ms-access)
  • Re: Timeout Expired
    ... So the timeout occurs during the bulk load operations? ... did you check the SQL Error Logs to see more clues about the timeout problem if there is any? ... locked for DML operations by SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Increase Connection Command timeout globally
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... in Stored procs which is causing it to timeout. ... Connection and Command timeout settings are done on the client. ... I expect you'll have to visit each Command object declaration and set the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Timeout Errors - Can Anyone Help?
    ... The timeout period elapsed prior to completion of the ... SQL Server does not time out. ... and you get further blocking and timeout. ... There are two possible reasons why a query takes more than 30 seconds ...
    (comp.databases.ms-sqlserver)
Quantcast