The Microsoft Distributed Transaction Service crashes when DTS is used to transfer data between SQL Server and Oracle Database

Article translations Article translations
Article ID: 829179 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

The Microsoft Distributed Transaction Service (MSDTC) may crash when Data Transformation Services (DTS) is used to transfer data between Microsoft SQL Server and Oracle Database.

CAUSE

This problem occurs because the MSDTC does not correctly change its internal state when it receives a connection_down message from Oracle Database.

RESOLUTION

How to obtain the hotfix

This issue is fixed in the Windows 2000 Server COM+ 1.0 Hotfix Package 28. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
828748 FIX: Availability of Windows 2000 Post-Service Pack 4 COM+ 1.0 Hotfix Rollup Package 28

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section of this article.

Properties

Article ID: 829179 - Last Review: November 8, 2004 - Revision: 3.1
APPLIES TO
  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Professional Edition
  • Microsoft Windows 2000 Advanced Server
  • Microsoft COM+ 1.0
Keywords: 
kbbug kbfix kbqfe kbwin2000presp5fix KB829179

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com