Does SQL and/or ODBC have a long timeout value? Run Time Error?

• shahin056

  Newbie

  Points: 1

  More actions

  January 2, 2011 at 1:12 am

  #232565

  My question is, does SQL and/or ODBC have a long timeout value? Run Time Error?

  We have an application running on a MS SQL database connected by ODBC on Windows XP machines and were plagued by 08s01 communication link failure errors. They always occurred between 3.30 to 4.30pm and 5:30 and 6:45 in the evening and we completely upgraded the network to remove potential network issues. Some users continued to get the error, and always in the late afternoon/early evening, and so we asked them to reboot their machines at lunchtime. Hey presto, the errors no longer happen. Accordingly I am wondering if there is a setting to kick out clients after they have been connected for eight or nine hours or so? I don't believe it to be inactivity because the users are reporting the error whilst working on the app, and the error is consistently occurrinig at a set number of hours after they have first logged into the app.

  Am I barking up the wrong tree here or is there a hidden setting somewhere?

  Any help would be greatly appreciated.

  Thanks,

  Shahin

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  January 2, 2011 at 5:29 pm

  #1268345

  There is not default timeout like you describe. I have often left connections open for days at a time or even weeks.

  It is more likely to be a bug in the application than anything to do with the server - it may even be that some process is starting late in the afternoon that slows the response down when a client requests data from the server and the application is timing out on the return of the data and not handling it well.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]