Microsoft KB Archive/888755

From BetaArchive Wiki
Knowledge Base


FIX: Messages are not sent by the BizTalk Server 2004 Adapter for SQL Server

Article ID: 888755

Article Last Modified on 12/23/2004



APPLIES TO

  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Standard Edition, when used with:
    • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
    • Microsoft Windows Server 2003, Standard Edition (32-bit x86)




SYMPTOMS

Messages that are delivered to a Send port that is bound to a Transport Type property value of SQL may not be sent by the Microsoft BizTalk Server 2004 Adapter for SQL Server. The Health and Activity Tracking (HAT) tool displays the following status for the messages:

Delivered, not consumed

When this problem occurs, you receive no error messages and the Application log has no record of this problem.

This problem may occur after you upgrade your server to Microsoft Windows Server 2003.

RESOLUTION

To resolve this problem, visit the following Microsoft Knowledge Base article and install the hotfix:

828943 FIX: COM interop call may return incorrect HRESULT


Keywords: kbtshoot kbbug kbfix kbbtsadapters KB888755