what is the Benefit of wrapping database calls into MTS
transactions?
Answer Posted / guest
If database calls are made within the context of a
transaction, aborting the transaction will undo and changes
that occur within that transaction. This removes the
possibility of stranded, or partial data.
Transaction that uses the Microsoft? Transaction Server
(MTS) environment. MSMQ implicitly uses the current MTS
transaction if one is available.
BENIFTIS OF USING MTS :
Database Pooling, Transactional operations, Deployment,
Security, Remote Execution
This allows MTS to reuse database connections. Database
connections are put to ?sleep? As opposed to being created
and destroyed and are activated upon request.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can I speed up my VB database application?
How do I make an animated icon for my program?
How can you force new objects to be created on new threads?
Scope of API?s can be of different types, what are they Why API functions are Required?
Explain the differences between ActiveX Dll and ActiveX Exe?
what are the Types of Resultsets?
How to down load image properties.
Can a VB application be an OLE server?
I'm getting error message "Reserved Error [-nnnn] ("There is no message for this error")" from Jet Engine 2.0.Why?
___ property used to add a menus at runtime.
Draw Sequence Modal of RDO? Explain.
How many objects resides in ADO ?
1.What are the Feactures visual data manager 2.Short note on visual data manager 3.What is data control,its work,properties,methods 4.Needs for OLEDB in vb 5.LIst steps involved in generating christal report 6.What is a recordset 7.Diffrence between RDO and ADO 8.What is an Activex control 9.Advantages of ADO over data control 10.Diffrence between model and modeless form 11.What is the significance of debug window 12.Diffrence between single document and multiple document 13.Explain data report
With in the form we want to check all the text box control are typed or not? How?
How many objects resides in ADO ?