Fw: error when doing transactions

Hazarul Azhar Harun <[email protected]> Fri, 19 Apr 2002 14:32:09 +0800
Newsgroups gmane.comp.windows.devel.vbcom
Message-ID <[email protected]>
I've fixed the problem by increasing the transaction global timeout value in
COM+..thanks to all
----- Original Message -----
From: "Chris Gallucci" <[email protected]>
To: <[email protected]>
Sent: Thursday, April 18, 2002 7:13 PM
Subject: Re: [VBCOM] Fw: error when doing transactions


> Make sure that the component generating the error isn't calling a stored
> procedure which has it's own transaction support in T-SQL.
>
> ChrisG
>
> ----- Original Message -----
> From: "Hazarul Azhar Harun" <[email protected]>
> To: <[email protected]>
> Sent: Wednesday, April 17, 2002 9:22 PM
> Subject: [VBCOM] Fw: error when doing transactions
>
>
> > hi yall....
> > I need help on this one. Why whenever I run this particular program, I
> will
> > get this  error?
> >
> > Run-time error '-2147217900(80040e14)':
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Distriubted transaction
> > completed. Either enlist this session in a new transaction or the NULL
> > transaction.
> >
> > I have a few programs that utilize transaction via COM+, everyone of
them
> > works okay. This is the only program
> > that has this error on it. TIA!
> >
> > You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
> > subscribe to other DevelopMentor lists at http://discuss.develop.com.
>
> You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
> subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.