Tags "msdtc" Result

confusion about transactions and msdtc

I have some basic confusion about how transactions and msdtc work together. I have a basic server/client winforms app. The app uses transactionscope to encapsulate several sql commands that are executed on the sql server. The app seemed to work fine when I enabled msdtc network access on the server only. Then one day it stopped working saying net

it1352 1 2019-05-06

MSDTC and firewall

We are using MSDTC for SQL transactions. I am having issue with setting up firewall for MSDTC to work. The application and SQL are running on separate machine. Currently MSDTC is working if i turn off firewall on application server. I think there should be someway to add exception to the firewall setting for some ports. So that firewall can still b

it1352 0 2020-11-08

TransactionScope won't work with DB2 provider

I've been trying to use TransactionScope with a DB2 database (using DB2 .Net provider v 9.0.0.2 and c# 2.0) which SHOULD be supported according to IBM. I have tried all the advice i could find on the IBM forums (such as here) to no avail. I have enabled XA transactions on my XP Sp2 machine, tried also from a Win 2003 Server machine but i consiste

it1352 3 2019-05-15

Why is TransactionScope using a distributed transaction when I am only using LinqToSql and Ado.Net

We are having problems on one machine, with the error message: "MSDTC on server XXX is unavailable." The code is using a TransactionScope to wrap some LingToSql database code; there is also some raw Ado.net inside of the transaction. As only a single sql database (2005) is being accessed, why is a distributed transaction being used at all

it1352 1 2019-05-07

Transaction manager

If I use .Net System.Transactions.TransactionScope class for a transaction across multiple tables in Oracle database, which one will be used LTM[Lightweight transaction manager] or MSDTC[Microsoft distributed transaction coordinator]? Is there any rule or strategy beind the scenes for deciding which one to use and when? Please advise. Also, wanted

it1352 0 2019-05-07

Reason for System.Transactions.TransactionInDoubtException

I have 2 Jobs that read and produce data in a Sql Server Database. Every once in a while the jobs crash with a System.Transactions.TransactionInDoubtException. The exact stack trace is: Unhandled Exception: System.Transactions.TransactionInDoubtException: The transaction is in doubt. ---> System.Data.SqlClient.SqlException: Timeout expired. T

it1352 1 2019-05-06

MSDTC: Communication with the underlying transaction manager has failed

I have a WinForms / WCF / SQLServer app where I am trying to use MSDTC transactions like this: using System.Transactions; // ... var transOptions = new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = TimeSpan.FromSeconds(120) }; using (var scope = new TransactionScope(TransactionScopeOpt

it1352 0 2019-05-10