I am somewhat under the gun (yes, on the weekend) to figure out how to call
the SQL Adapter from an orchestration that Inserts data into a database.

I know how to set it up to 'select' data, but my confusion is that when I
get to the location where it shows all the input parameteres to the stored
procedure, it seems to expect me to enter the actual data beside the check
boxes.

I suppose if I check the checkbox that means it can go in as null, but how
do I actually pass data from a message into the sql adapter?

Thanks for any help.

Norton

[ Post a follow-up to this message ]

OK, I have gone through and looked at the Loan Application and although I
don't want to do anything quite that complex with my stored proc, it seems
that I understand what it is doing, however, mine does not work this same.

I do this:
1. Create a new BizTalk project.
2. Add a generated item, go through and select the SQL adapter. I also set
my target namespace and select this to be a 'Send' port.
3. I select my stored procedure, click on generate and then finish and I
have a schema. My schema has two root elements, one for the request and one
for the response. The elements are named according to my previous entries.
4. When I go into my orchestration, I add a port to the drawingi surface and
say that 'I will be sending a request and recieve a response'. I also choose
to use an existing port type which is of type SQLServiceExec. My port is
created.
5. Now at this point, I 'thought' a message named 'Message_1' should have
been created for me, but maybe not, I don't see one. What I do see though is
that in the orchestration viewer tab, Multi-part message types, I see a
'procedureRequest' and a 'procedureResponse'. Since I do not have any
messages that correspond to these message types, I create two new messages.

Now here is the interesting thing, when I create a new message and attempt
to reference the schema that I will be pointing to, I can see a listing for
<MyProjectName>.<RequestRootElementName>. In the SDK example, I see a
listing for Loan_Acceptance.procedureRequest and
Loan_Acceptance.procedureResponse. Why do I not see
<MyProjectName>.procedureRequest etc????? In the Loan application, the root
elements in the schema created by the adapter wizard are not named
'procedureRequest'.

6. So, anyway, I move ahead, creating a Request message also.
7. I create an orchestration where I have a send shape that references my
request message and a receive shape that references my response message. No
matter what I do, the orchestration designer will not let me connect my send
shape to the ports request connector.

So, I am quite baffled and frustrated. Is it really this hard to just call a
stored procedure to insert some data.????

PLEASE HELP!

Norton
"TheNortonZ" <thenortonz@hotmail.com> wrote in message
news:uVgz88irEHA.3244@tk2msftngp13.phx.gbl...
>I am somewhat under the gun (yes, on the weekend) to figure out how to call
>the SQL Adapter from an orchestration that Inserts data into a database.
>
> I know how to set it up to 'select' data, but my confusion is that when I
> get to the location where it shows all the input parameteres to the stored
> procedure, it seems to expect me to enter the actual data beside the check
> boxes.
>
> I suppose if I check the checkbox that means it can go in as null, but how
> do I actually pass data from a message into the sql adapter?
>
> Thanks for any help.
>
> Norton
>

[ Post a follow-up to this message ]

Ah Ha! 

I found that whenever I created my messages and then pointed to the schemas 
in my project, I should have chosen the ones under Multi-Part message type.

Then, once I got my send port setup correctly, I was all set.

Norton
"TheNortonZ" <thenortonz@hotmail.com> wrote in message news:O$I2G0krEHA.896@TK2MSFTNGP12.phx
.gbl...
> OK, I have gone through and looked at the Loan Application and although I 
> don't want to do anything quite that complex with my stored proc, it seems
 
> that I understand what it is doing, however, mine does not work this same.
> 
> I do this:
> 1. Create a new BizTalk project.
> 2. Add a generated item, go through and select the SQL adapter. I also set
 
> my target namespace and select this to be a 'Send' port.
> 3. I select my stored procedure, click on generate and then finish and I 
> have a schema. My schema has two root elements, one for the request and on
e 
> for the response. The elements are named according to my previous entries.
> 4. When I go into my orchestration, I add a port to the drawingi surface a
nd 
> say that 'I will be sending a request and recieve a response'. I also choo
se 
> to use an existing port type which is of type SQLServiceExec. My port is 
> created.
> 5. Now at this point, I 'thought' a message named 'Message_1' should have 
> been created for me, but maybe not, I don't see one. What I do see though 
is 
> that in the orchestration viewer tab, Multi-part message types, I see a 
> 'procedureRequest' and a 'procedureResponse'. Since I do not have any 
> messages that correspond to these message types, I create two new messages
.
> 
> Now here is the interesting thing, when I create a new message and attempt
 
> to reference the schema that I will be pointing to, I can see a listing fo
r 
> <MyProjectName>.<RequestRootElementName>. In the SDK example, I see a 
> listing for Loan_Acceptance.procedureRequest and 
> Loan_Acceptance.procedureResponse. Why do I not see 
> <MyProjectName>.procedureRequest etc????? In the Loan application, the roo
t 
> elements in the schema created by the adapter wizard are not named 
> 'procedureRequest'.
> 
> 6. So, anyway, I move ahead, creating a Request message also.
> 7. I create an orchestration where I have a send shape that references my 
> request message and a receive shape that references my response message. N
o 
> matter what I do, the orchestration designer will not let me connect my se
nd 
> shape to the ports request connector.
> 
> So, I am quite baffled and frustrated. Is it really this hard to just call
 a 
> stored procedure to insert some data.????
> 
> PLEASE HELP!
> 
> Norton
> "TheNortonZ" <thenortonz@hotmail.com> wrote in message 
> news:uVgz88irEHA.3244@tk2msftngp13.phx.gbl... 
> 
>

[ Post a follow-up to this message ]

Hi,
I too had similar issue, I tried following similar steps u have taken but
still not able bind my send shape to to request port in my orchestration.
Please explain importance of multi part message type when using request
response ports.



"TheNortonZ" wrote:
[vbcol=seagreen]
> Ah Ha!
>
> I found that whenever I created my messages and then pointed to the schema
s in my project, I should have chosen the ones under Multi-Part message type
.
>
> Then, once I got my send port setup correctly, I was all set.
>
> Norton
> "TheNortonZ" <thenortonz@hotmail.com> wrote in message news:O$I2G0krEHA.89
6@TK2MSFTNGP12.phx.gbl... 

[ Post a follow-up to this message ]