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
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
I have created two different Contexts for two different databases in Entity Framework. Now I am trying to update these databases in single transaction. My code is like that:
public class LPO_BLL
internal Context1 _context1 = null;
internal Context2 _Context2 = null;
public LPO_Detail_BLL(Context1 context1, Context2 context2)
I want confirm if the Transaction that Entity Framework's ObjectContext.Connection.BeginTransaction() method returns uses the support of MSDTC (Microsoft Distributed Transaction Coordinator) or not?
Is there any way to use transactions without support of MSDTC?
Solution It will automatically promote to a transaction coordinated by MSDTC under ce
I've been trying to use TransactionScope with a DB2 database (using DB2 .Net provider v 18.104.22.168 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
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
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?
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
I have a WinForms / WCF / SQLServer app where I am trying to use MSDTC transactions like this:
var transOptions =
IsolationLevel = IsolationLevel.ReadCommitted,
Timeout = TimeSpan.FromSeconds(120)
using (var scope = new TransactionScope(TransactionScopeOpt
I am using MVC 3 with Entities, now I have used the below line of codes from my controller
using (var scope = new TransactionScope())
and inside my DeleteFM2 method which happens to be my method define