Distributed Transaction

  • Thread starter Thread starter Karthikeyan
  • Start date Start date
K

Karthikeyan

Please give your valuable suggestions on the following:

1. Is it possible to support Distributed Transaction (Two Phase Commit)
without COM+ or MTS "using C#"?

2. Can I use the MS DTC sdk to achieve Two phase commit from C# Code? If yes
can you tell me where I will get the related materials (MS DTC SDK Reference
Manual)



Thanks in advance.
 
¤ Please give your valuable suggestions on the following:
¤
¤ 1. Is it possible to support Distributed Transaction (Two Phase Commit)
¤ without COM+ or MTS "using C#"?
¤
¤ 2. Can I use the MS DTC sdk to achieve Two phase commit from C# Code? If yes
¤ can you tell me where I will get the related materials (MS DTC SDK Reference
¤ Manual)

Transaction handling is a function of ADO.NET, a middleware component such as COM+, and the database
server. There are different methods to handling transaction processing, but none of it is specific
to the language (e.g. C# and VB.NET).


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
My requirement is different. I want to implement two phase locking without
mts or com+

 
¤ My requirement is different. I want to implement two phase locking without
¤ mts or com+
¤

You don't have to use COM+ or MTS. Transactions are typically supported by the database provider
libraries that operate with ADO.NET. For example, you can use the SQLTransaction class to work with
transactions in SQL Server at the application level.

You can also implement your transactions using SQL code within stored procedures at the database
server level.

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpref/html/frlrfSystemDataSqlClientSqlTransactionClassCommitTopic.htm


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi,
Thanks for your infomation.

My req is like this..

I have one SQL Server database and one oracle database....

I want to insert one one record in each database.. with in a transaction
context???

(Note : I have to connection object)
How to do that??

Thanks in advance

Regards,
Karhtikeyan



Paul Clement said:
¤ My requirement is different. I want to implement two phase locking without
¤ mts or com+
¤

You don't have to use COM+ or MTS. Transactions are typically supported by the database provider
libraries that operate with ADO.NET. For example, you can use the
Click to expand...
SQLTransaction class to work with
Click to expand...
 
¤ Hi,
¤ Thanks for your infomation.
¤
¤ My req is like this..
¤
¤ I have one SQL Server database and one oracle database....
¤
¤ I want to insert one one record in each database.. with in a transaction
¤ context???
¤
¤ (Note : I have to connection object)
¤ How to do that??
¤
¤ Thanks in advance
¤

Under this scenario I would use two separate transactions, one for SQL Server and one for Oracle. If
the fist operation fails, e.g. SQL Server, then the Oracle update would not be performed. If the
second operation fails, e.g. Oracle, then you would rollback the SQL Server transaction. If both
succeed then commit both transactions.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top