RE: wish to not receive a response

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


Date: Thu, 9 Sep 2004 07:51:03 -0700

I also know the SPROCs are working because testing them in Query Analyzer,
information is getting writting into the dB.

"fzee" wrote:

> 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: wish to not receive a response
    ... Their is no SPROC, ... I am mapping my schema to the SQLService.xsd schema. ... > XML to SQL, and it was taking one of the element names in my bad XML and ... > In your case he thinks the stored procedure is 'spTest'. ...
    (microsoft.public.biztalk.general)
  • Re: wish to not receive a response
    ... >> Their is no SPROC, element or value named spTest. ... >> and the response to be spTest. ... >> I am mapping my schema to the SQLService.xsd schema. ...
    (microsoft.public.biztalk.general)
  • RE: how to send an xml dataset to a Stored Procedure in mssql
    ... I'm not understanding this...I can get the SPROC to run when i insert the ... but I do need to passs the xml file in as a variable. ... >> hold parsed xml stream ...
    (microsoft.public.dotnet.languages.csharp)
  • 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)
  • RE: Pass XML between SPROCs possible in SQL 2000? 2005? (Cross Post - Sorry)
    ... Welcome to MSDN newsgroup. ... Microsoft Online Support ... I can create an XML fragment using the For XML Auto clause. ... | the parameter for the sproc in part B. Is that possible? ...
    (microsoft.public.sqlserver.xml)