Distributed transaction

[newbie14]

Dear All,
I have a C# application where I need a distributed transaction. I need to update 2 database one local and one remote. Is there any idea how to to do it? Any code snippet will be helpful? Thank you.

 

[ingresman]

Do you just want to open connections to two databases on two seeprate servers or do you want to do a real two-phase commit transaction.
If it's the former, that's easy enough just open two ADO.NET connection in the C# code. If it's the latter you will need to make sure that the provider you are using will enlist in a distributed tranaction (I think the MYSQL .NET provder does) and then run you aplication under a distributed transaction coordinator(what used to be DTC) running uner MTS (or .net transaction services as I think it's called these days, its also been called COM+).
If you running Tuxedo or Encina for windows you will have to consult thier documentation.
Best bet it to look at the documentation or ask in the C#/.NET forums, it should be straight forward.

 

[newbie14]

Dear Ingresman,
I would like to do the former one open the connection and commit together. So I would want the real two-phase commit. Is there any sample code how to go about it. I have checked the mysql .net connector is not supporting yet. Any other option please.

 

[ingresman]

Have a look at this

http://support.microsoft.com/kb/316247

and

http://www.c-sharpcorner.com/Upload...onScope04142006103850AM/TransactionScope.aspx

However

http://social.msdn.microsoft.com/Fo...g/thread/b2383a8d-a186-4fe3-9b67-6fffc2a72885

Seems to indicate that the mysql connector does not support transactions
But

http://dev.mysql.com/doc/refman/5.1/en/connector-j-versions.html

Says the the Java connector does support distributed transactions (XA)
So it's looks a little confused !, you could also try the ODBC connector which I can't see specific reference to XA but is a rewrite do probabbly does.
Try some of the examples and see if it works !

 

[newbie14]

Dear Ingresman,
Actually the reason why I was using .net connector was that first I read an article stating that .net connector is much faster then odbc. So actually what is odbc and oledb.net. I am a bit confusing do you think I must go back to there ? Thank you.

 

[ingresman]

To behonest I'd try and find some articles on data access under windows. It should save you a lot of trouble in the long run.

 

[newbie14]

Dear Ingresman,
I dont get you when you said you have tried? Actually what do u mean you have tried what .net connector or oledb or odbc? From your experience which is better now? Thanks.

 

[ingresman]

I've never tried to do a distributed two phase commit (XA) using MYSql.
I think the performance differecne betweeen the ODBC/OLD Db/ .net probabbly only matters if you have a very high throughput application. Twp Phase Commit is quite a slow protocol so I would think you wouldn't see a great deal of difference.
I'm also not really sure what your asking me in your last post.

 

[newbie14]

Dear Ingresman,
Since .net connector does not support two phase commit so what is your option for me to try do you think I should try it with ole db.net or odbc ? So which one have you use I mean in you db software application for thow phase commit ?

 

[ingresman]

how can I put this.....
I've never done a two phase commit
Try the ODBC connector for yourself !.
for a .NET application you don't have any other options I'm afraid.

 

[newbie14]

Dear Ingresman,
Ok then I just would like to know further details from you wat is odbc and oledb.net what is their difference?

 

[ingresman]

don't know