MTSTransactionMode vs COM+ transaction supported

Posted on 2003-02-28
Medium Priority
Last Modified: 2007-12-19
I have a vb dll in which the MTSTransactionMode is set to 0. i put dll in com+ and specify it as transaction supported. Can you plese tell me if this object when called from a asp code runs inside a transaction or not
Question by:platinum505
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

NicolNghia earned 300 total points
ID: 8055523
Hi platinum,

I think the answer is YES (not tested). NotAnMTSObject(0) is default value for MTSTransactionMode. However we can change this later by using setting in MTS when deploy the .dll.
You can test this fast by bulding a component that has one method that perform 2 update SQL statements. The first SQL statement is valide and the second SQL statement is invalid. This component is NotAnMTSObject at design time.

When deploy this on MTS set this to RequiresTransaction(2). And call the mothod from ASP. If the first SQL statement is not effected. That mean it support Transaction.

Good luck,

Author Comment

ID: 8061876
Thanks very much for the practical way, rather than giving some lengthy description.

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack or Above. The following steps a…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month8 days, 17 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question