Microsoft KB Archive/331547

= PRB: BizTalk Adapter for SQL Server AIC Does Not Support Writing to Linked Servers =

Article ID: 331547

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft BizTalk Adapter for SQL

-



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=&quot;0x80040e14&quot; Source=&quot;Microsoft OLE DB Provider for SQL Server&quot; Description=&quot;The current transaction could not be exported to the remote provider. It has been rolled back.&quot;



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.

Keywords: kbprb KB331547

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.