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" <(E-Mail Removed)> wrote in message
news:eDwVO5$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:#$(E-Mail Removed)...
> > "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.
> >
> >
> >
>
>
Similar Threads
