"Transaction context in use by another session"

Hi.
I'm getting the "Transction context in use by another session" error when
saving data to SQL server 7.0 from ASP using <%@ TRANSACTION =Requires_New
%> . No DTS is involved.

The error only occurs sometimes and seems to have nothing to do with the
amount of data saved. Could have something to with the number of users on
the webapplication though.
Have searched solutions on the net, microsoft MSDN.

Please help. Thanks.

Re: "Transaction context in use by another session"

msnews.microsoft.com wrote:
> Hi.
> I'm getting the "Transction context in use by another session" error
> when saving data to SQL server 7.0 from ASP using <%@ TRANSACTION
> =Requires_New %> . No DTS is involved.
>
> The error only occurs sometimes and seems to have nothing to do with
> the amount of data saved. Could have something to with the number of
> users on the webapplication though.
> Have searched solutions on the net, microsoft MSDN.
>
> Please help. Thanks.

Are you explicitly committing your transactions? Rolling them back when
errors occur?
Are you properly closing your connections when done with them?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: "Transaction context in use by another session"

Hi.

I'm neither committing nor rolling back the transactions. The IIS handles
the proccess using MTS, and the system aborts the transaction because of the
error described. That is the asp page is halted and thus the abort occurs.

The real problem is the "Transction context in use by another session". It
occurs somewhere on the asp page executing several sql statements.

Thanks.


"Bob Barrows [MVP]" wrote in message
news:uiehfImJFHA.3788@tk2msftngp13.phx.gbl...
> msnews.microsoft.com wrote:
> > Hi.
> > I'm getting the "Transction context in use by another session" error
> > when saving data to SQL server 7.0 from ASP using <%@ TRANSACTION
> > =Requires_New %> . No DTS is involved.
> >
> > The error only occurs sometimes and seems to have nothing to do with
> > the amount of data saved. Could have something to with the number of
> > users on the webapplication though.
> > Have searched solutions on the net, microsoft MSDN.
> >
> > Please help. Thanks.
>
> Are you explicitly committing your transactions? Rolling them back when
> errors occur?
> Are you properly closing your connections when done with them?
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Re: "Transaction context in use by another session"

msnews.microsoft.com wrote:
> Hi.
>
> I'm neither committing nor rolling back the transactions.

I think that's part of the problem then. You should take control of this
process and explicilty issue commit/rollback statements as the situations
require.

> The IIS handles the proccess using MTS, and the system aborts the
> transaction
> because of the error described. That is the asp page is halted and
> thus the abort occurs.

Don't depend on automated processes. They sometimes don't work as you would
expect.
>
> The real problem is the "Transction context in use by another
> session".

No, no, no. This error message is a SYMPTOM of a problem that needs to be
solved. The problem is that you have an uncommitted/unrolledback transaction
in process when you attempt to execute a new sql statement. The goal is to
prevent this from happening by taking explicit control of the process.

From a Google search, I came up with the following KB references that may
help:
Here are some possible MS KB articles references: 215520 , 191168 , 279857
256649 180843 274348

You can either use the search interface at support.microsoft.com to find
these articles, or use urls like:

http://support.microsoft.com/?kbid=215520

substituting the kb article id's as needed.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"