I've implemented the beer house application for a client of mine. The only component that I'm using is the shopping cart. As I'm sure many of you know the beer house uses the MSDTC service to handle the go between the shopping cart and paypal.
The hosting option that I have does not allow me to make use of this service. I would have to get a dedicated server, which makes no sense because this site does not expect a huge amount of traffic.
So my quesion: is there an alternative to using the MSDTC? if so can you point me in the right direction.
If you're using SqlServer add Enlist=false; to your connection string--this will disable transactions. MSDTC allows rolling back transactions that are on different connections, otherwise you'll need to create a giant stored procedure and place several
sql statements inside a transaction inside the procedure. In other words, you're going to have to disable transactions, use MSDTC, rewrite large sections of BeerHouse into weaker code, or write the code to do roll-backs yourself. He talks about this in the
book.
Ya changing into weaker code not a good idea. The whole reason I chose this shopping cart was because of the MVC architecture. In changing to a different hosting company that supporst MSDTC.
przemeklach
Member
227 Points
119 Posts
Alternative To Using MSDTC Service
Nov 21, 2007 08:42 PM|LINK
Hi,
I've implemented the beer house application for a client of mine. The only component that I'm using is the shopping cart. As I'm sure many of you know the beer house uses the MSDTC service to handle the go between the shopping cart and paypal.
The hosting option that I have does not allow me to make use of this service. I would have to get a dedicated server, which makes no sense because this site does not expect a huge amount of traffic.
So my quesion: is there an alternative to using the MSDTC? if so can you point me in the right direction.
Thanks.
JustinHolton
Member
516 Points
114 Posts
Re: Alternative To Using MSDTC Service
Nov 28, 2007 03:22 PM|LINK
If you're using SqlServer add Enlist=false; to your connection string--this will disable transactions. MSDTC allows rolling back transactions that are on different connections, otherwise you'll need to create a giant stored procedure and place several sql statements inside a transaction inside the procedure. In other words, you're going to have to disable transactions, use MSDTC, rewrite large sections of BeerHouse into weaker code, or write the code to do roll-backs yourself. He talks about this in the book.
przemeklach
Member
227 Points
119 Posts
Re: Alternative To Using MSDTC Service
Dec 01, 2007 10:23 PM|LINK
Hi thanks for your reply.
If I just Enlist=false, do I risk data corruption?
Thanks.
JustinHolton
Member
516 Points
114 Posts
Re: Alternative To Using MSDTC Service
Dec 03, 2007 05:20 PM|LINK
Well, you won't be using transactions so obviously if one SQL statement errors out you would. You'll have to write the code to check for that.
przemeklach
Member
227 Points
119 Posts
Re: Alternative To Using MSDTC Service
Dec 07, 2007 11:20 PM|LINK
Ya changing into weaker code not a good idea. The whole reason I chose this shopping cart was because of the MVC architecture. In changing to a different hosting company that supporst MSDTC.
Thanks for your help.