Connection to Transaction Manager failed

[Debra McCarney]

I am using <%@ transaction=required %> at the top of my
ASP page, then doing several very straightforward ADO
updates to a SQL Server database in the one transaction in
the page. I don't do any explicit CommitTrans etc, as I
understand that MTS then handles the transaction
committing it when the page is finished executing. Most of
the time this works fine, but every now and then the error
message "Provider Error '8004d10c' - connection to the
transaction manager failed" is generated. The only way I
have found to get out of this is to reboot the server, not
the ideal solution!!
Does anyone know why this is happening? My current
solution is to change all my data access to stored
procedures and explicitly handle my transaction processing
there, giving up on the ASP transaction directive.

[Richard Marr]

Hi Debra

I did some research on the error and saw some cases which were resolve
by the following article

814119 FIX: RPC Bug Causes Threads to Stop Responding in ASP/COM+
Applications
[url]http://support.microsoft.com/?id=814119[/url]

You did not mention what operating system you are running but if this is
the issue that you are running into the article mentions that this is fixed
in SP4 for Windows 2000. If you are unable to test this and need want to
get the hotfix you will need to contact our Product Support 800-936-5800
who will verify the exact problem and supply the hotfix accordingly.

HTH

"This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2002 Microsoft Corporation. All
rights reserved."

Richard Marr
Microsoft IIS Support Professional

[Debra McCarney]

I have checked with the Systems Administrator and we are indeed running
Windows 2000 SP3. He is currently awaiting SP4, so I am hoping that will
solve the problem. Thanks for your advice.

Debra McCarney
Systems Consultant
DBR Group Pty Ltd

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!