0

Does anyone know how to set the ConnectionTimeout and/or CommandTimeout in NetTiers as I have a long running query that is timing out. I expect the query to be long running, its not a performance problem as such, I just need to know if anyone knows how to set this value.

Dejo
  • 2,078
  • 3
  • 26
  • 38
Mike D
  • 220
  • 1
  • 4
  • 12

1 Answers1

1

You need to add it to the Web.config for the generated site. Its the defaultCommandTimeout provider in the Provider setting.

Carol Skelly
  • 351,302
  • 90
  • 710
  • 624
  • Thanks, i'll check that out and get back to you. If I knew how to put a bounty on this question - i might do that too !! – Mike D Sep 11 '09 at 10:24
  • Your answer is correct, so thanks, however, nettiers doesn't seem to always follow the command, ONCE it did, other times it didn't, but thanks, I was able to find more references on the web based on your answer. – Mike D Sep 21 '09 at 12:24
  • @MikeD It would be interesting if you could tell us what else you found. – Jean-François Beauchamp Sep 21 '12 at 20:16
  • so long ago, I can't remember now ! – Mike D Nov 02 '12 at 11:49
  • Custom stored procedures ignore this setting btw. http://nettiers.net/FrequentlyAskedQuestions.ashx?AspxAutoDetectCookieSupport=1#I_set_the_codeNetTiersProviderDefaultCommandTimeoutcode_property_so_why_does_my_slow_Sproc_time_out_using_the_SQL_provider_8 – Rebecca Mar 03 '14 at 12:15