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