SQLXML Webservice setup problem - InfoPath Dev
in

InfoPath Dev

SQLXML Webservice setup problem

Last post 12-06-2005 06:50 AM by Butterbull. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 12-05-2005 07:12 AM

    SQLXML Webservice setup problem

    Hi

    We've coded and tested a few forms successfully retrieving data from webservices running on a Win2K server with SQLXML SP3.

    We are now trying to move from our development box to a new test server for the client, this server is Win2003.

    When I try and connect to the webservices from within infopath, it picks up the parameters, but as soon as I try and move past sample value screen it gives me the folowing error:

    //----------------------------------------------------
    The SOAP response indicates that an error occurred:

    The input parameter 'tns:CompanyID' is not a parameter to the stored procedure called.
    //----------------------------------------------------

    The SQL DB and Template files is exactly the same as the Win2K server.
    Everything is basicly mirrored from development box.

    I'm sure we're just missing something small, but can't seem to find the problem....

    Thanks


  • 12-05-2005 11:28 AM In reply to

    Re: SQLXML Webservice setup problem

    Ouch... Couple things could come to mind but I would be guessing on how you got there.

    Have you tried refreshing your secondary data source to your web service? Just go Modify on your data source >> go through the wizard again >> let it rebuild the data source. Hope that helps.
    Jason
    http://www.k2distillery.com/
  • 12-05-2005 11:29 PM In reply to

    Re: SQLXML Webservice setup problem

    Thanx for the response...

    I created brand new forms and tried to create new datasources through the wizzard. It gets all the correct parameters for the sample values, but fails to go to the next screen... default values.

    Passing the paramaters directly to the template files in IE works.
    Do you know of another way that I could test the webservices SQLXML creates.

    I'm relatively new to webservices...not to sure where to go from here...

    Thanks
  • 12-06-2005 06:50 AM In reply to

    Re: SQLXML Webservice setup problem

    Solved the problem...

    SOAP Toolkit 2.0 SP2, SQLXML 3.0, Win2K -> works
    on Win2K3 SOAP Toolkit 3.0 must be installed with SQLXML 3.0

    Thanks
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.