| Author |
Passing parameters to stored procedures through SQL Adapter
|
|
|
| Hy people
Do the sql adapter have any problens on using stored procedures with
parametrs??
I've seen some samples of sql adapter and none of them use SP's with
parameters.
Can anyone help me please?
| |
| JGaska [http://www.IoniaSolutions.com] 2005-04-27, 5:52 pm |
| Felix;
Have a look at the sample in the sdk
Program Files\Microsoft BizTalk Server
2004\SDK\Samples\Adapters\SQLAdapter\Loa
n Acceptance
I believe all your answers are within that sample.
-Joe
"Felix" wrote:
> Hy people
>
> Do the sql adapter have any problens on using stored procedures with
> parametrs??
> I've seen some samples of sql adapter and none of them use SP's with
> parameters.
> Can anyone help me please?
>
>
>
| |
|
| Thank's
I can call my procedures now, however when I try to read the response I have
the flowing error
Received unexpected message type 'MyNamespace#SQLResponse' does not
match expected type 'MyNamespace#SQLResponse'.
I've used the HAT to inspect the message generated by SQL and it's fine.
What could be going wrong
"JGaska [http://www.IoniaSolutions.com]"
< JGaskahttpwwwIoniaSolutionscom@discussio
ns.microsoft.com> wrote in message
news:E58952BB-8475-4ED5-9C48-B17CCA84092D@microsoft.com...[vbcol=seagreen]
> Felix;
>
> Have a look at the sample in the sdk
>
> Program Files\Microsoft BizTalk Server
> 2004\SDK\Samples\Adapters\SQLAdapter\Loa
n Acceptance
>
> I believe all your answers are within that sample.
>
> -Joe
>
>
>
> "Felix" wrote:
>
| |
|
| Hi Felix,
Look in the Newsgroup called "Application Integration" for a post that was
made on 4/17/2005 titled "SQL Server Stored Procedure call."
I responded to his question, along with another person. You can definitely
pass params but I had difficulties using the SDK sample. I found an article
on the web (referenced in that post) that helped walk me through each of the
steps. You will be able to piece together enough info to get what you need
to do. Good luck.
Michael
"Felix" wrote:
> Hy people
>
> Do the sql adapter have any problens on using stored procedures with
> parametrs??
> I've seen some samples of sql adapter and none of them use SP's with
> parameters.
> Can anyone help me please?
>
>
>
|
|
|
|