I'm currently upgrading an app to SQL 2008 / Server 2008 R2 x64 and I'm seeing some strange behaviour that I have not seen on SQL 2005 / Server 2003. Randomly I get an exception from MSDTC: The partner transaction manager has disabled its support for remote/network transactions. (Exception from [...] read more
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 void DeleteGroupDetails(int groupId) { // Note there is no ambient tx var thisIsNull = Transaction.Current; using (var scope [...] read more
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 TransactionScope()) { try { Store.DBDataContext dc = new Store.DBDataContext(); Store.Product product = GetProduct("foo"); dc.InsertOnSubmit(product); dc.SubmitChanges(); transaction.Complete(); } catch (Exception ex) { [...] read more
When am using sequence container to roll back my transactions in execute sql task i am getting the error Connection manager Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 "The partner transaction manager has disabled its support for remote/network [...] read more
I have got two DbContexts(One Model-first and the other one is code first) which connects to two different databases in MSSQL. Now when you call SaveChanges from any class, it writes data to both the databases at the same time using TransactionScope class. Code looks like below. using (TransactionScope scope [...] read more
The main issue here makes it different from other available problems and solutions (here) is that, I am working with a previously working M# project and right now after upgrading to M# v4.8.334 (or maybe some other modifications regarding Visual Studio 2017 installation), if I want to add any new [...] read more
I'm using NServiceBus as a transport layer on a project. Currently both endpoints are on my local machine. I'm getting the follow exception :"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)". Again, this is completely local. I've read all the posts I could [...] read more
I am using transaction scope. I want to have a transaction scope for 2 queries that are run in different database servers. One query runs on one server and the other one runs in a different server. However a single query will have its own transaction scope as it is [...] read more
if writing below codes: Error returns.i do like advise : http://stackoverflow.com/questions/794364/how-do-i-use-transactionscope-in-c But only error change:The partner transaction manager has disabled its support for remote/network transactions Exception from HRESULT: 0x8004D025 i am using windows server 2003. using (var stockMovementCtx = new StockMovementCtxDataContext()) { using (var scope = new TransactionScope()) { // [...] read more
I have some code which is doing something like this (please note that the actual code is much more complex). I have produced this to aid explanation: Imports System.Data.SqlClient Imports System.Transactions Public Class Form1 Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Using scope As New [...] read more
I have a simple update method like below: public static void Execute() { var conn = new SqlConnection(ConnectionString); conn.Open(); var cmd = new SqlCommand(UpdateQuery, conn); cmd.ExecuteNonQuery(); } CASE 1 When I call this method from a Console Application everything works as expected. Since I do not Complete the TransactionScope update [...] read more
I have two different entities of different databases. In my process I want to manipulate both databases, and the whole process must be in transaction. I have tried with TransactionScope. It works fine for single entity. var entity1 = clsProject.GetEntity1(); var entity2 = clsProject.GetEntity2(); System.Transactions.TransactionScope tranScope = new System.Transactions.TransactionScope(); entity1.Connection.Open(); [...] read more
I am trying to Enable SSL for database connection with setting the encrypt=true;trustServerCertificate=true on the connection string, everything is working fine until when I want to use TransactionScope, and I am getting below exception, The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025) If [...] read more
I get the following exception when I connect my application to the remote data base and there is no exception when I connect my application to the local database. What is the problem? I also have searched my problem in www.google.com. I have found many solution and I follow those [...] read more