Distributed transaction problem

I am using COM+ components, every client request kicks of
a chain call of these components. One of the components
executes a SQL query, and this fails every time for a
particular client request. I am getting the following
exception on execution of the query.

Distributed transaction completed. Either enlist this
session in a new transaction or the NULL transaction.
System.Exception

_stackTraceString " at
System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader
(CommandBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Execu
teReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand
(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
dataSet)

Database : SQL Server 2000 SP3
.Net server : Windows 2003 Server on Dual processor m/c
Data provider : OleDb
MDAC : 2.7

Angel
Tue Sep 02 13:28:15 CDT 2003

Could you post some more information?

When you open a connection without specifying Enlist=false it will
automatically look up the stack for an available distributed transaction,
when one is present the connection will auto enlist into this distributed
transaction.

Angel



"Zameer Mohammed" <zameer823@yahoo.com> wrote in message
news:060d01c3715c$242a7cc0$a001280a@phx.gbl...
> I am using COM+ components, every client request kicks of
> a chain call of these components. One of the components
> executes a SQL query, and this fails every time for a
> particular client request. I am getting the following
> exception on execution of the query.
>
> Distributed transaction completed. Either enlist this
> session in a new transaction or the NULL transaction.
> System.Exception
>
> _stackTraceString " at
> System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
> at System.Data.OleDb.OleDbDataReader.NextResult()
> at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
> (CommandBehavior behavior, String method)
> at System.Data.OleDb.OleDbCommand.ExecuteReader
> (CommandBehavior behavior)
> at
> System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Execu
> teReader(CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.FillFromCommand
> (Object data, Int32 startRecord, Int32 maxRecords, String
> srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet, Int32 startRecord, Int32 maxRecords, String
> srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet)
>
> Database : SQL Server 2000 SP3
> .Net server : Windows 2003 Server on Dual processor m/c
> Data provider : OleDb
> MDAC : 2.7
>
>

IbrahimMalluf
Tue Sep 02 14:37:16 CDT 2003

Zameer;

you may be getting timeout errors or lock conflicts, or some other failure
causing the transaction to close. Make sure you are not locking any rows!

Ibrahim

"Zameer Mohammed" <zameer823@yahoo.com> wrote in message
news:060d01c3715c$242a7cc0$a001280a@phx.gbl...
> I am using COM+ components, every client request kicks of
> a chain call of these components. One of the components
> executes a SQL query, and this fails every time for a
> particular client request. I am getting the following
> exception on execution of the query.
>
> Distributed transaction completed. Either enlist this
> session in a new transaction or the NULL transaction.
> System.Exception
>
> _stackTraceString " at
> System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
> at System.Data.OleDb.OleDbDataReader.NextResult()
> at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
> (CommandBehavior behavior, String method)
> at System.Data.OleDb.OleDbCommand.ExecuteReader
> (CommandBehavior behavior)
> at
> System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Execu
> teReader(CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.FillFromCommand
> (Object data, Int32 startRecord, Int32 maxRecords, String
> srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet, Int32 startRecord, Int32 maxRecords, String
> srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet)
>
> Database : SQL Server 2000 SP3
> .Net server : Windows 2003 Server on Dual processor m/c
> Data provider : OleDb
> MDAC : 2.7
>
>