BizTalk SQL Adpater Send-Receive not working Sending Data to Database and reciving data from that same port.is it possible

Question

BizTalk SQL Adpater Send-Receive not working
Sending Data to Database and reciving data from that same port.is it possible

Answer 1

Yes it is possible. You can use the store procedure in SQL and and pass data to its parameters and can get data from it. What exactly is your requirement.

---

Please mark as answer or vote as helpful if my reply does [Regards-Rohit Sharma http://rohitbiztalk.blogspot.com/]

Answer 2

It is possible and this link might help http://www.codeproject.com/KB/biztalk/usingsqladapter.aspx

---

Thanks, Raja

Answer 3

Hi Niranjan,

Your requirement is quite possible using BizTalk SQL Adapter. But I would suggest you to use the WCF based SQL Adapter.

Sample links:

http://geekswithblogs.net/bosuch/archive/2010/10/19/biztalk---simple-wcf-tutorial-for-using-a-stored-procedure.aspx

Rgds,

Abhijit

---

Abhijit Mahato - Microsoft Community Contributor 2011 - MCTS BizTalk Server blog: http://abhijitmahato.wordpress.com/ Please "Mark as Answer" if Post has Answered the Question

Answer 4

Hi,

If you are performing table operation or calling a stored procedure then it will go through same port. For guidance/example see my post on table operations and calling stored-procedure. I agree/second Abhijit comment on using WCF-SQL. If you are working with BizTalk 2009 or 2010 then you should. The SQL Adapter is deprecated and will be enhanced any longer.

HTH

Regards,

Steef-Jan Wiggers
MVP & MCTS BizTalk Server 2010
http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

 

---

BizTalk