469,271 Members | 1,484 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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

"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.

Nov 16 '05 #1
3 27101
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

"Ollie Riches" <ol**********@phoneanalyser.net> wrote in message
news:#$*************@TK2MSFTNGP15.phx.gbl...
"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.

Nov 16 '05 #2
Your MSDTC has timed out. You need to increase the timeout

"Ollie Riches" <ol**********@phoneanalyser.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...
"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.

Nov 16 '05 #3
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/


"Ollie Riches" <ol**********@phoneanalser.net> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl...
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

"Ollie Riches" <ol**********@phoneanalyser.net> wrote in message
news:#$*************@TK2MSFTNGP15.phx.gbl...
"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.


Nov 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Lada 'Ray' Lostak | last post: by
3 posts views Thread by Peter Theill | last post: by
1 post views Thread by craigkenisston | last post: by
10 posts views Thread by Kurda Yon | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.