msdtc Questions
3
While creating an SSIS package for SQL Server 2008 i run into the following error:
Error: The SSIS Runtime has failed to
start the distributed transaction due
to error 0x8004D01B "The Transact...
Leblanc asked 15/9, 2009 at 12:9
11
Solved
I'm trying to run SQL against a linked server, but I get the errors below :
BEGIN DISTRIBUTED TRANSACTION
SELECT TOP 1 * FROM Sessions
OLE DB provider "SQLNCLI" for linked server "...
Makeshift asked 19/9, 2011 at 15:40
7
I have hosted my WebApp on server 1 and my database on server 2
But I'm getting following error
Communication with the underlying transaction manager has failed.
I googled and found a post which ...
Cherish asked 16/9, 2014 at 7:2
9
Solved
I get this weird error on SQL Server. And I cannot find solution in older posts.
I have this procedure:
create proc _upJM_SyncAll_test
as
begin
DECLARE @SQLString nvarchar(max)
set @SQLString ...
Yowl asked 2/4, 2015 at 13:31
2
Solved
I have the following code sample:
static void Main(string[] args)
{
TransactionManager.DistributedTransactionStarted += (sender, eventArgs) =>
{
Console.WriteLine("Promoted to distributed tr...
Garek asked 2/12, 2019 at 8:56
7
Solved
I'm trying to run a distributed transaction from my machine (SQL Server 2012) to a client server (SQL Server 2008).
I'm trying to run:
begin distributed transaction
select * from [172.01.01.0...
Yoheaveho asked 3/6, 2014 at 12:3
3
I setup a LinkedServer from SqlServer 2014 to MySQL 5.7.3 running on my Win 10 PC. Both select & insert queries work fine alone via openquery, but the insert query won't function in a trigger. ...
Celom asked 10/9, 2016 at 17:20
7
Solved
Is this even a valid question? I have a .NET Windows app that is using MSTDC and it is throwing an exception:
System.Transactions.TransactionManagerCommunicationException: Network access for Dis...
Nigercongo asked 11/8, 2008 at 11:57
1
I'm migrating a local SQL Server development database to run in a Linux docker container (on the same dev machine). When running my integration tests in Visual Studio 2019 on Windows, I receive MSD...
Bordy asked 9/11, 2020 at 4:11
1
Azure failed to marshal transaction into propagation token for elastic transaction (Works for MSDTC)
In windows azure we have hosted two asp.net webapi project as app service. We need to enable distributed transaction here. We initiate transaction inside one api. Then inside that transaction scope...
Earthwork asked 19/12, 2017 at 6:0
3
Solved
I have been working on a winform app with Oracle 10g database which is using TransactionScope and wanted to modify the maxTimeOut value specified in machine.config file, my machine.config file is i...
Conversant asked 29/4, 2013 at 14:27
1
Solved
I'm hunting down a bug in a large business application, where business processes are failing but partially persisted to the database. To make things harder to figure out, the process fails only onc...
Courser asked 2/9, 2019 at 21:13
7
Solved
In our project we're using TransactionScope's to ensure our data access layer performs it's actions in a transaction. We're aiming to not require the MSDTC service to be enabled on our end-user's m...
Susian asked 6/11, 2009 at 22:24
7
Solved
I am using MVC 3 with Entities, now I have used the below line of codes from my controller
using (var scope = new TransactionScope())
{
_myRepository.DeleteFM1(id);
_myRepository.DeleteFM2(id, ...
Florescence asked 27/4, 2012 at 7:17
1
Solved
Is it possible to have a transaction between an on premises SQL Server instance and an Azure SQL database.
I have the following tests cases.
public class TransactionsTest
{
[Fact]
public void T...
Jemy asked 13/9, 2018 at 19:12
5
Solved
I am trying to set up a simple transaction for my Linq-to-Sql actions against my Sql 2000 database. Using TransactionScope it looks like this:
using (TransactionScope transaction = new Transaction...
Seagrave asked 26/11, 2008 at 15:0
1
Solved
In my code there are transactions to handle:
using (var scope = new TransactionScope())
{
repo1.SaveSomething();
repo2.SaveAnythingElse();
scope.Complete();
}
Inside repo1 and repo2 functions...
Physiotherapy asked 23/1, 2018 at 10:38
4
Solved
I am getting error:
communication with the underlying transaction manager has failed
when I am trying to run my application from visual studio 2010. I have search on google for this problem, ...
2
Solved
Simple question but I can't find the answer anywhere: is Active Directory transaction-aware?
In other words, will the following change be rolled back (since I didn't call scope.Complete()):
using...
Roberson asked 7/8, 2009 at 14:19
8
Solved
I followed the KB article from MS in order to turn on MSDTC trace. Unfortunately it was hard to follow, since it doesn't assume a very reasonable and obvious expectation of the reader, specifically...
3
Solved
I'm currently trying to use nested transaction scopes for DB access against an Azure SQL Database.
I'm using the following code (.Net 4.5.1, my code is async all the way down, it's ASP.Net MVC wit...
Budge asked 13/8, 2015 at 15:39
8
Solved
in our current project we are using ADO.NET Entity Framework as data layer for the application. There are some tasks which require to run in a transaction because there's a lot of work to do in the...
Patentee asked 23/10, 2009 at 7:52
2
Solved
I've used DTCTester before to diagnose MSDTC problems. However, I just noticed DTCPing seems to do about the same thing. What's the difference between these two?
From what I can tell so far, DTCPi...
Hypomania asked 1/10, 2008 at 19:3
1
I can't find answer anywhere.
I will show simple code fragment which presents how to easily corrupt connection pool.
Connection pool corruption means that every new connection open try will fai...
Saunderson asked 20/5, 2014 at 10:0
1
Solved
I am unable to get the following code that only touches a single database using a single context to run without escalating to MSDTC, and is throwing an exception on context.SaveChanges():
public v...
Fortalice asked 31/10, 2014 at 17:45
1 Next >
© 2022 - 2024 — McMap. All rights reserved.