Transaction Abort while connect a db from customized module.

Topics: Customizing Orchard, General, Troubleshooting
Mar 28, 2012 at 10:54 PM

In one common action of my customized module, I create a SqlConnection and then call con.Connect() straight away.  then I receive a "Distributed Transaction is aborted" and "MSDTC is not available" exceptions.  I wonder how does it trigger the distributed transaction?


It seems my msdtc is running fine cos I have other app on my pc using msdtc perfectly running.  
please tell me what happened to the action controller and how to fix it.
thank heaps.  All I want is to save sth to a db on the server.