Last post Dec 07, 2007 07:20 PM by przemeklach
Nov 21, 2007 04:42 PM|przemeklach|LINK
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.
Nov 28, 2007 11:22 AM|JustinHolton|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
Dec 01, 2007 06:23 PM|przemeklach|LINK
Hi thanks for your reply.
If I just Enlist=false, do I risk data corruption?
Dec 03, 2007 01:20 PM|JustinHolton|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.
Dec 07, 2007 07:20 PM|przemeklach|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.