0

We need a to run a distributed application using C#. The problem we found the .net connector with mysql does not support this. We found this devart product which claim to support it. Any one with experience using mind to share how to it works or is there any better tool?

new14
  • 703
  • 1
  • 10
  • 16
  • What devart product is that? – Chris Sinclair Jan 12 '13 at 01:21
  • Actually, the .Net Connector does support distributed [transactions][1]. [1]: http://stackoverflow.com/questions/7265734/why-does-opening-a-connection-throw-a-distributed-transactions-error-in-mysql – AngryHacker Jan 12 '13 at 01:22
  • @AngryHacker so you mean to say AutoEnlist=false. So in my case I got 3 distributed connection any code sample for me to follow? – new14 Jan 12 '13 at 02:19
  • @AngryHacker as per my knowledge no doubt .net connector has transaction scope but does not support distributed transaction am I right? – new14 Jan 12 '13 at 02:29
  • @new14 Yes, setting AutoEnlist to false should make your distributed transaction work. I am not sure whether it has a dependency on MSDTC - make sure to turn that on as well (including XA transactions). – AngryHacker Jan 12 '13 at 03:06
  • @AngryHacker this I guess applies to the latest .net connector right? So must I have the msdtc you are also not sure about it? – new14 Jan 12 '13 at 04:06
  • In SQL Server world, you must have MSDTC on all the endpoints (e.g. the pc where the app is running, db server 1 and db server 2). As far as the latest connector, I am not entirely sure. – AngryHacker Jan 12 '13 at 04:20
  • @AngryHacker I am fully based on mysql any idea? – new14 Jan 12 '13 at 15:54
  • @new14 Afaik, the parties wanting to participate in a transaction must enlist in an MSDTC distributed transaction. Not sure how mysql does it. – AngryHacker Jan 13 '13 at 05:49
  • @AngryHacker looks like mysql is missing this feature I guess. – new14 Jan 14 '13 at 10:09

0 Answers0