"Distributed transaction completed. Either enlist this session in a new transaction or the NULL tran

[Ollie Riches]

"Distributed transaction completed. Either enlist this session in a new
transaction or the NULL transaction."

I am recieving the above error when attempt to access a remote sql server
database 2000 (sp3a) from ADO.Net.
The database is on a windows 2003 machine and the ado.net code (web
services) are on another winsdows 2003 machine in the same domain. I have
configure the DTC to allow transactions and followed the resolution in the
following KB but I am still getting the error.

http://support.microsoft.com/?kbid=834849

Anyone got any ideas?

Cheers

Ollie Riches
http://www.phoneanalyser.net


Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

 

[Ollie Riches]

The answer was that the enterprise component (COM+) was 'hiding' certain
exception information and that the problem actual was a database table
constraint issue nothign related to the DTC

Ollie

 

[Stan]

Your MSDTC has timed out. You need to increase the timeout

 

[Angel Saenz-Badillos[MS]]

Thank you for posting the result back into the newsgroup, it is really
appreciated. I am glad to hear that you got this working, I am always
interested in hearing about peoples experiences with Distributed
Transactions, especially regarding the upcoming 2.0 System.Transactions.

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/