an problem wiht sql adapter

an problem wiht sql adapter

Post by stone_fred » Thu, 13 May 2004 17:18:14

I have an sql port bound to an port of two orchestration.
one work, while another does. the failure reason is as follow,
The "SQL" adapter is suspending an outbound message going to destination
Can any body give some hints on how to solve the problem.

1. WCF-SQL BizTalk Adapter (LOB Adapter Pack 2.0) Performance

2. BTS 2006 SQL Adaptor responce Message problem

The solution is very simple. If you are using Request and Responce type port thenfor SQL ,go to responce operation and set the message type as System.xml.document type and add a recieve shape of the same type to access the above message .If you want to drop this failed message then add a send shape, set the message type as System.Xml.Document and follow passthrowTransmit for this send port. This error message will be drained out. Cool.....

3. Disass. Result Sets Using SQL Adapter Problem

4. Please Help - BizTalk 2006 and SQL Adapter - Transaction coordinator problem

5. Huge problem with generating response schema using SQL Adapter - Kevin

6. SQL Adapter Problems

7. Problem in passing parameter to Stored Procedure using SQL adapter

8. SQL Adapter problem - multiple body parts

9. sql adapter problem with large text parameter

10. Sql Adapter Problem.

11. BizTalk - Sql Adapter MSDTC Problem

12. SQL Adapter, Multiple Receive location problem

13. Biztalk Adapter for SQL Server Problem

14. SQL Adapter and MSDTC problem with Windows 2000

15. Problem with SQL adapter in BizTalk 2006 Beta2?