By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,018 Members | 1,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,018 IT Pros & Developers. It's quick & easy.

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

P: n/a
"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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.