Distributed Transaction Error
Praveena
We have a asp page in which we are making some update calls connecting
to SQL Server 2000. For this we have to treat this page as a transaction so
we used the directive "@Transaction=required". When we give this then the
page is giving "Distributed Transaction Error". And the strange part is this
was working fine with the directive given in the page till last week monday.
Since then it is giving this error when we try to display this page. Then we
tried out by removing this directvie ...strangely its works fine.
I do not understand what the problem is ... please somebody help me
regards
Praveena
Ryan Lu [MSFT]
When adding the statement "@Transaction=required", the data access in your
ASP page will participate in a distributed transaction, which the error was
prompting you. The logical distributed transaction relies on the underlying
physical MSDTC transaction. Please check the DTC/Network/SQLServer to solve
the problem. For further information, please refer to the following
Microsoft Knowledge Base article
"191168 INFO: Error "-2147168246 (8004d00a)" Failed to Enlist on Calling
Object"
http://support.microsoft.com/?id=191168
If the problem still exists, please post the exact error description
including the error code.
Best regards,
Ryan Lu
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Praveena
Here is the error which we are getting
*********************************************************
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed transaction error
/vault/DBConnection1.asp, line 7
sorry the details are not updated
*********************************************************
I have checked with our hosts about the DTC/Network/SQLServer. They replied
saying that they can ping the two server where our app is running and the
server where our SQL is being shared by name not by ipaddress. On the client
side also we have the DTC running. The strange part is that ...our app was
running fine previously in which we did include the directive "@
Transaction="Required"". Please help us in this regard.
Regards
Praveena
"Ryan Lu [MSFT]" <ry...@online.microsoft.com> wrote in message
news:6bBIVWz$CHA....@cpmsftngxa06.phx.gbl...
Ryan Lu [MSFT]
Again I think it is a DTC related issue. Any events in the event logs? Can
you help to perform the DTCPing test following the KB article?
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
If the DTCPing failed, you can perform these steps until the problem is
solved:
1. Make sure there is no name resolution problem which will cause troubles
in MSDTC communication
2. Assign the DTC services on all the machines with the same user account
and restart them.
3. Reinstall the DTC services.
HOWTO: Reinstall MS DTC for a Nonclustered Windows 2000 Server
http://support.microsoft.com/?id=279786
I suggest you contact your local PSS for help since troubleshooting DTC is
a complex issue, and it is strongly recommended to involve PSS when
re-installing your DTC services.