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
What is snapshot in vb?
How can I call a 'hidden' DOS program from VB?
Explain the "cursortype" and "Locktype" in VB?
Write the Steps in Creating an ActiveX Control?
Recordset object consists what?
Can you tell me the properties of the controls?
How come I get a "No Current Record" error when I use a a Data Control on an empty table?
Types of cursors in RDO.
How to get Cursor position using API?
How do I implement an accelerator key for a text box?
How can Visual Basic be used for server-side scripting?
Through which protocol OLEDB components are interfaced?
Is the Variant type slower than using other variable types?
___,_____ and ____ container objects.
how to use unicode data in vb6 regarding to telugu language, my output is in only telugu language