The Microsoft Distributed Transaction Service crashes when DTS is used to transfer data between SQL Server and Oracle Database
This article has been archived. It is offered "as is" and will no longer be updated.
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.
This problem occurs because the MSDTC does not correctly change its internal state when it receives a connection_down message from Oracle Database.
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:
FIX: Availability of Windows 2000 Post-Service Pack 4 COM+ 1.0 Hotfix Rollup Package 28
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section of this article.
Article ID: 829179 - Last Review: 01/10/2015 14:40:41 - Revision: 4.0
- Microsoft Windows 2000 Server
- Microsoft Windows 2000 Professional Edition
- Microsoft Windows 2000 Advanced Server
- Microsoft COM+ 1.0
- kbnosurvey kbarchive kbbug kbfix kbqfe kbwin2000presp5fix KB829179