RE: wish to not receive a response

From: fzee (fzee_at_discussions.microsoft.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 07:31:09 -0700

Thanks for the responses.

I did use the Add Generated Items - Adapters...and selected the correct
SPROC. A SQLService.xsd was created for me.

Their is no SPROC, element or value named spTest. When I ran the Wizard
that generated the SQLService.xsd file, I specified the request to be spSend
and the response to be spTest. So that's why I think it has something to do
with the response.

I am mapping my schema to the SQLService.xsd schema.

Thanks

"Neal Walters" wrote:

> I was getting the same message last week. I think I was sending the wrong
> XML to SQL, and it was taking one of the element names in my bad XML and
> assuming it was the stored procedure name.
>
> In your case he thinks the stored procedure is 'spTest'. Is that one of
> your element names or values? Did you use the "Add Generated Items" and use
> the SQL wizard to build the proper schema fo your call to Stored-Procedure?
> Did you map your XML to this schema?
>
> Neal Walters
> http://Biztalk-Training.com - Free Video Tutorials
>

Relevant Pages

  • Re: SQL Send Adapter
    ... "Alan Smith" wrote: ... > 1 Set the field for the XML part of the SQL insert message to distinguished. ... >> I am clear on how to create the schema and the ports; ... >> on how to pass the input XML message to the stored procedure. ...
    (microsoft.public.biztalk.general)
  • Re: SQL Send Adapter
    ... I am trying to use this suggestion without success so far. ... Set the field for the XML part of the SQL insert message to distinguished. ... I am clear on how to create the schema and the ports; ... on how to pass the input XML message to the stored procedure. ...
    (microsoft.public.biztalk.general)
  • Re: SQL Send Adapter
    ... You can use an expression shape in the orchestration for this. ... Set the field for the XML part of the SQL insert message to distinguished. ... > I am clear on how to create the schema and the ports; ... > on how to pass the input XML message to the stored procedure. ...
    (microsoft.public.biztalk.general)
  • BizTalk 2004: Orchestration question, string message -> xml message transformation
    ... Stored procedure and return some data. ... flat-file which I've already made the schema for. ... on that xml. ...
    (microsoft.public.biztalk.general)
  • Using sp_run_xml_proc inside transaction
    ... a stored procedure. ... The sproc creates a SQL Server COM object basically to provide client-side ... My problem is in trying to call this procedure inside a transaction, ... sp_run_xml_proc to get some XML to see if things worked, ...
    (microsoft.public.sqlserver.programming)