I'm developing a (C#) n-tier application and have looked a little at COM+,
thinking it might be a good Data Access Layer Component.
But whenever I try to call a method on my COM+ component I get this error:
"The partner transaction manager has disabled its support for remote/network
transactions"
My component is placed on a WinXP machine, while the SQL Server 2000
database is installed on Windows Server 2003. Is this a problem?
I checked ALL checkboxes in the MSDTC | Security Configuration... | Security
Settings area on both computers as described here:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=ORdkGu4SDHA.
1912%40TK2MSFTNGP12.phx.gbl
What am I doing wrong?
Here's a code-sample of my COM+ component (if it's any help?):
[Transaction(TransactionOption.Required)]
public class ComComponentForDBAccess : ServicedComponent
{
public ComComponentForDBAccess()
{
}
[AutoComplete]
public string GetSomethingFromDB()
{
//... implementation here
}
}
Any help will be greatly appreciated,
Kenneth
Brad - 17 Dec 2003 16:19 GMT
Kenneth,
Your setup of XP -> WS03 is fine. There are 2 articles that come to mind
here, one of which you've already seen. Let me know if neither one of
these gets you up & running...
817064 HOW TO: Enable Network DTC Access in Windows Server 2003
http://support.microsoft.com/?id=817064
817065 HOWTO: Enable Network COM+ Access in Windows Server 2003
http://support.microsoft.com/?id=817065
HTH,
Brad
john smith9th - 19 Dec 2003 06:08 GMT
change "TransactionOption.Required" to "TransactionOption.supported"
> I'm developing a (C#) n-tier application and have looked a little at COM+,
> thinking it might be a good Data Access Layer Component.
[quoted text clipped - 8 lines]
> I checked ALL checkboxes in the MSDTC | Security Configuration... | Security
> Settings area on both computers as described here:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=ORdkGu4SDHA.
1912%40TK2MSFTNGP12.phx.gbl
> What am I doing wrong?
>
[quoted text clipped - 16 lines]
> Any help will be greatly appreciated,
> Kenneth