Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Fredrik Esseen 608 posts 904 karma points
    Mar 15, 2012 @ 09:04
    Fredrik Esseen

    Timeout expired when using SqlHelper.ExecuteReader


    Im using SqlHelper.ExecuteReader to query the databse, but the problem is that the querystring is quite long. Is it possible to change the CommandTimeout somehow so that the query has time to process?

  • Rodion Novoselov 694 posts 859 karma points
    Mar 15, 2012 @ 20:57
    Rodion Novoselov

    Hi. It's a sad thing, but there's absolutely no way to set CommandTimeout through the connection string or any other configuration setting. May be in your situation you could just put off using SqlHelper and simply use SqlCommand manually in order to set a longer timeout on it in your code.

Please Sign in or register to post replies

Write your reply to: