msdtc Questions
4
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 = I...
2
Solved
are there any alternative to transactionScope which does not need to enable DTC??
In the transaction I need to make two operations:
Create one user (using membership - sql membership provider)
D...
Evidentiary asked 28/6, 2012 at 11:42
4
Our team have got a problem that manifests as:
The underlying provider failed on EnlistTransaction; Cannot access a
disposed object.Object name: 'Transaction'.
which seemed to appear as soo...
Ague asked 29/4, 2013 at 16:21
3
Solved
Using Entity Framework (code first in my case), I have an operation that requires me to call SaveChanges to update one object in the DB, and then SaveChanges again to update another object. (I need...
Ignescent asked 9/10, 2012 at 23:40
3
1/ The following code snippet show me the expected error: The INSERT statement conflicted with the FOREIGN KEY constraint FK_...
SET XACT_ABORT ON;
BEGIN TRANSACTION
INSERT INTO linkedsrv1.db1....
Naarah asked 8/1, 2014 at 11:31
4
Solved
I am using NServiceBus for the first time and have a small, simple application where a user submits a form, the form fields are then sent to the queue, and the handler collects this data and writes...
Korwun asked 19/7, 2011 at 13:46
2
Solved
Note Please see Update 6. It has a simple app that demonstrates how to recreate the problem.
I'm living a DTC nightmare... Our setup is that we have two databases; a SQL Server 2008 database and a...
Eskimo asked 7/10, 2013 at 20:51
1
I'm trying to use TransactionScope for unit tests and I keep getting errors on our build server. After following several helpful SO answers and blogs, I installed DTCPing and ran it on both server1...
Huttan asked 28/7, 2011 at 18:1
4
Just curious if anyone else has got this particular error and know how to solve it?
The scenario is as follow...
We have an ASP.NET web application using Enterprise Library running on Windows Ser...
Teamwork asked 30/6, 2009 at 3:6
2
Solved
When we need to do database access in our application, we use the following patterns:
For querying, we have a static factory class with a method CreateOpenConnection which does nothing more than ...
Socage asked 31/5, 2013 at 9:50
1
I got the following exception in my application once,
Unable to get the address of the distributed transaction coordinator for the server, from the server. Is DTC enabled on the server?
Now I ...
Privy asked 14/3, 2013 at 13:39
3
Solved
Is it possible to use the System.Transactions programming model without support for distributed transactions?
something like
TransactionConfig.DisablePromotion = true;
3
I am just starting to work with using TransactionScope, I find that there are always unexpected things I run into that take forever to debug.
I figure that having a consolidated list of these wou...
Tamekia asked 18/11, 2009 at 21:21
0
Recently I encountered an error :
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction
It was mentioned in one of the replies in a forum , that one ...
Bogard asked 10/1, 2013 at 4:22
3
Solved
This problem is not readily reproducible in a simple example here but was wondering if anyone has any experience and tips, here is the issue:
using Entity Framework
have many points in applicati...
Demote asked 3/3, 2010 at 10:38
0
We are occasionally seeing the error "MSDTC encountered an error (HR=0x80000171) while attempting to establish a secure connection with system [servername]" on our servers. We are using NServiceBus...
Spermatozoid asked 29/11, 2012 at 0:53
1
Solved
I'm trying to use System.Transactions (TransactionScope) to coordinate a set of processes, each of which does some database work. Ultimately all processes need to commit or be rolled back atomicall...
Ritualize asked 26/11, 2012 at 22:28
4
I have an ASP.NET MVC3 application that uses an EF 4.1 DbContext, database-first data layer. The EDMX approach works fine as I tend to make changes to my data model before adapting the application ...
Chinachinaberry asked 13/9, 2012 at 14:50
4
I have a web application that uses the Entity Framework - we make use of the TransactionScope class to provide ambient transactions.
Is there any way to tell EF to use a standard T-SQL transaction...
Escaut asked 8/1, 2010 at 9:39
1
Solved
Specs:
Sql Server 2008
Server 2008 R2 64bit
MS Access database
What works:
I have configured a Linked server connection to the Access database by installing office access data components and ...
Goldman asked 20/7, 2012 at 8:21
2
Solved
From what I'm reading, in order to use TransactionScope in .NET, you need the Distributed Transaction Coordinator service in Windows to be running. I have that service turned off, and my app seems ...
Period asked 31/1, 2012 at 5:58
4
Solved
I came across this very odd situation, and i thought i would throw it up to the crowd to find out the WHY.
I have a query that was joining a table on a linked server:
select a.*, b.phone
from tab...
Amoeboid asked 25/1, 2012 at 20:20
3
Solved
We have clustered MSMQ for a set of NServiceBus services, and everything runs great until it doesn't. Outgoing queues on one server start filling up, and pretty soon the whole system is hung.
More...
Expiable asked 6/10, 2010 at 16:3
7
Solved
I am using the .NET 2.0/3.5 framework for my application. I need to run several SQL commands across multiple connections and each connection is on a different server (Oracle, SQL Server). I need to...
Eleneeleni asked 20/5, 2009 at 13:10
2
Solved
DTCPing tool says everything should be fine. The actual exception is:
System.Transactions.TransactionManagerCommunicationException:
Communication with the underlying transaction manager has f...
Cauterant asked 17/8, 2011 at 9:42
© 2022 - 2024 — McMap. All rights reserved.