Scott Woodgate’s sql adapter examples

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Scott Woodgate’s sql adapter examples

Viewing 1 reply thread
  • Author
    Posts
    • December 2, 2006 at 5:21 PM #16677
      community-content

        Hi,

        I know this is a long shot but I am desperate. I have been trying to learn how to use sql adapter and was doing fine until the very last example SQL2WaySend. I am on the final part connecting the orchestration and I cannot get it to connect to the SQL2WayPort? I am fairly new and I'm having a hard time as it is grasping how this works, so I don't have a clue what is supposed to be happening. Could anyone please, if you have a spare minute just look over the last part of the example and let me know how I am supposed to connect the sql ports to the orchestration? For instance, how many different messages should there be? I thought 4 but just from looking at the screen shot he has included I can only see 2?

        http://blogs.msdn.com/scottwoo/archive/2004/03/11/88387.aspx

         

        Thanks a million,

        Sharon

      • December 2, 2006 at 5:53 PM #16679
        community-content

          And the only way I can connect to the sql ports is the send_1 to the SQL2WSendPort(response) and the receive_2 to SQL2WSendPort(request), which is the opposite way around?!? :S

          • December 2, 2006 at 7:16 PM #16680
            community-content

              From the Orchestration point of view, you would send a request and receive a response back.

               

              As far as the exact problem, I’m not really sure.  That sample is 2 ½ years old.  I quickly review it and it looked like it should work.  I think what should happen is to send a message and return an errors / status from SQL.

               

              Maybe a better place to look is the SQL Adapter White Paper or some of the sample that might be around for BizTalk 2006.

              • December 3, 2006 at 6:12 AM #16683
                community-content

                  The purpose of the example is to drop a document in a receive file that has a CustomerID(from Northwind database), this will then be sent to the sql request port which will respond with all the details for that customer and then this document is sent to another FileSendPort. 

                  Ok I made a tiny mistake- when configuring the sql request/response port, i choose "i will always be receiving a message then sending a response" so that explains why it was connecting the opposite way around.  But now that I have fixed it when I try to build I get 2 errors:

                  C:\BiztalkExamples\SQL2WaySendSample\BizTalk Orchestration.odx(287): use of unconstructed message 'Message_2'
                  C:\BiztalkExamples\SQL2WaySendSample\BizTalk Orchestration.odx(291): use of unconstructed message 'Message_4'

                  When building this I had 4 messages:

                  message_1: SQL2WaySendSample.SQLService.ReqRoot

                  message_2: SQL2WaySendSample.procedureRequest

                  message_3:SQL2WaySendSample.procedureResponse

                  message_4:SQL2WaySendSample.SQLService.RespRoot

                  This makes sense to me. But on his screen shot he has only 2 messages?! I realise this is a old example but for every 10 examples I am trying with Biztalk 2004 about 3 are actually working and it is just getting me more and more frustrated. I would really like to know what is it that is going wrong with this, and I think it should work like he said since I have followed the other examples exactly like he said and I had no problems with them.

                   Sharon

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