Problem with SQL adapter in biztalk 2006

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem with SQL adapter in biztalk 2006

Viewing 1 reply thread
  • Author
    Posts
    • February 25, 2008 at 6:03 AM #18983
      community-content

        Hi All,

         i developed an application which built and deployed fine. I used sql adapter to make the transactions, in receive folder the file is processed but i dont get it in send folder,  In HAT it shows ” Error details: HRESULT=”0x80004005″ Description=”Streaming not supported over multiple column result”

         

        Please help

      • February 26, 2008 at 10:04 AM #18988
        community-content

          Hello Stranger,

           Could you please provide more information. What is your stored procedure code like that is being called by the BizTalk SQL Adapter ? Are you trying to return multiple rows set of data or a single row of data, have you specified that the data being returned is in xml within the stored procedure? If you are trying to return multiple rows of data then it has to be catered for in your orchestration. This is my suspicion obviously it’s only a hutch because I need more information.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.