PRB: BizTalk Adapter for SQL Server AIC Does Not Support Writing to Linked Servers (331547)


The information in this article applies to:

  • Microsoft BizTalk Adapter for SQL Server 1.0
This article was previously published under Q331547

SYMPTOMS

When you try to send data to a linked data source in SQL Server by using the Microsoft BizTalk Adapter for SQL Server Application Integration Component (AIC), the data may not be written and you may receive an error message similar to the following in the Tracing Utility log:
2002-10:56:59.975,aicsql,BTSSQL_ERROR,SAXContent::processingInstruction,SAXContent_cpp416, SAXContent::processingInstruction- MSSQLError - HResult="0x80040e14" Source="Microsoft OLE DB Provider for SQL Server" Description="The current transaction could not be exported to the remote provider. It has been rolled back."

CAUSE

This error occurs because the BizTalk Adapter for SQL Server does not support writing data to a linked data source.

STATUS

This behavior is by design.

MORE INFORMATION

The BizTalk Adapter for SQL Server AIC supports writing data to a SQL database through SQLXML Updategrams. SQL Server supports methods to link to DB2 and Oracle databases. However, the BizTalk Adapter for SQL Server does not support using the AIC to send data to a linked data source in SQL.
Modification Type:MajorLast Reviewed:9/30/2003
Keywords:kbprb KB331547 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.