I had a very similar problem. I was adding several rows to different tables within a transaction using LINQ. Within the transaction scope I was calling a function which accessed the SQL server (not even the same database, but the same SQL server). When I
attempted to execute the transaction I got the same error you are getting. I moved the code that accessed the database outside the transaction scope so that I retrieved the value to a local variable, and, voila!!, the error went away.
BrinkSr
Member
2 Points
2 Posts
Re: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable D...
May 07, 2009 04:43 PM|LINK
I had a very similar problem. I was adding several rows to different tables within a transaction using LINQ. Within the transaction scope I was calling a function which accessed the SQL server (not even the same database, but the same SQL server). When I attempted to execute the transaction I got the same error you are getting. I moved the code that accessed the database outside the transaction scope so that I retrieved the value to a local variable, and, voila!!, the error went away.