I encountered an error when I tried to save (submit order) the items in the solution at the line:

cn.Open();

- from the public override int InsertOrderItem(OrderItemDetails orderItem) method.

The error message was:

MSDTC on server 'RS2H-LAP1154\DCF57AFB-1738-40' is unavailable.

I've tried it on both my WinXP Home and Win2000 Pro PCs but it produced the same error.

Can somebody help me with this?

Thanks.

Has anyone got any ideas on this previous post as it appears I have the same problem


cheers

MSDTC on server 'RS2H-LAP1154\DCF57AFB-1738-40' is unavailable.

This is the microsoft distributed transaction server. Try a google on that and see if you can find any links. from the brief description, it would appear that either you (or your hosters) transaction server service is either disabled or not running (or not installed).

jimi

http://www.jamestollan.com

I know nothing about the "transaction server service", what a "google" is, all I know is everyting works perfect on my own machine, this happens using server EXPRESS and IIS and it happens with my custom code and the Beerhouse code, most embarrising

again

"everything works perfect" that is until I reach this point in the code, this results in this message

MSDTC on server '*******\A5D66880-F45D-47' is unavailable.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: MSDTC on server '********\A5D66880-F45D-47' is unavailable.

Source Error:


Line 658: cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = orderItem.Quantity;
Line 659: cmd.Parameters.Add("@OrderItemID", SqlDbType.Int).Direction = ParameterDirection.Output;
Line 660: cn.Open();
Line 661: int ret = ExecuteNonQuery(cmd);
Line 662: return (int)cmd.Parameters["@OrderItemID"].Value;


Source File: c:\Documents and Settings\******\My Documents\TheBeerHouse\TBH_Web\App_Code\DAL\SqlCli ent\SqlStoreProvider.cs Line: 660

Sorted.......eventually worked it out

:)

Hello gb012993,
Can you please share the resolution? I have the same issue.



Thanks
Prasad