MSDTC error

Hi guys,
Im new to SQL Server development in general...Well, I've been trying to
work on an existing application that uses both ASP and SQL Server that
happened to be raising an error that is logged on the Event Viewer 15
minutes after closing the browser. Here it is:
Event Type: Information
Event Source: MSDTC
Event Category: (3)
Event ID: 4156
Date: 09/08/2005
Time: 12:56:28 PM
User: N/A
Description:
String message: Session idle timeout over, tearing down the session.
As it looks, it seems like a uncleared session state upon exiting the
ASP page. I then tried using Session.Contents.RemoveAll and
Session.Abandon methods but still got no luck on the ASP side...Is there
anyway this Informational Message won't get logged into the Event
Viewer? I dont really know if its ASP or SQL problem! hehe...
Your help will greatly be appreciated. Thanks!
*** Sent via Developersdex http://www.examnotes.net ***Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Check out http://support.microsoft.com/defaul...kb;en-us;290334 for
more information on the error. AFAIK, the message can't be suppressed.
Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Session is holding an object it should not hold. If it is database related,
it is likely a connection opened when a session starts that is never killed.
It is not necessarily SQL Server related.
I would post in the ASP group:
microsoft.public.inetserver.asp.general
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"jules remoreras" wrote:

> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>|||Gee...thanks to both of you (Dan and Cowboy) for the input!!! :) At
least the input/link you posted somehow enlighten my heavily burden
mind. hehehe. Thanks again!
*** Sent via Developersdex http://www.examnotes.net ***