Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</

  • Hi,

    I encounter this error in my application.

    "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

    I understand the difference between the 2 setting. One is for connection and the other is for query execution.

    Connect Timeout

    CommandTimeout

    Just want to understand that when we hit this error, is related to Connect Timeout

    - whereby the connection cannot be established to the database within x seconds or related to CommandTimeout

    - where by a particular query cannot complete the result by x seconds?

    wish to know so that i know which setting to tweak. thanks

  • Looks like CommandTimeout, not ConnectionTimeout.

    You can either increse the timeout or tune the query and make it complete before the timeout expires (default is 30 seconds).

    -- Gianluca Sartori

Viewing 2 posts - 1 through 1 (of 1 total)

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