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


The information in this article applies to:

  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Professional
  • Microsoft Windows 2000 Advanced Server
  • Microsoft COM+ 1.0

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.
Modification Type:MinorLast Reviewed:11/8/2004
Keywords:kbBug kbfix kbQFE kbWin2000preSP5fix KB829179 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.