SQLXML Webservice Parameters

[Butterbull]

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....

Any ideas?

 

[Pranav Wagh[MSFT]]

Hi,
Check if webservice is runnning outside IP; check if you are passing
correct parameter types in sample values, else it may need more research,
if required you may open a case with us

Pranav Wagh

"The Real Stuff Is oUT oF tHE bOX"

http://blogs.msdn.com/pranavwagh
http://spaces.msn.com/members/pranavwagh
http://pranavwagh.blogspot.com

--------------------
Thread-Topic: SQLXML Webservice Parameters
thread-index: AcX5spQCt0/FzLmETkmNsaKaY0kxPg==
X-WBNR-Posting-Host: 196.209.62.172
From: "=?Utf-8?B?QnV0dGVyYnVsbA==?=" <[email protected]>
Subject: SQLXML Webservice Parameters
Date: Mon, 5 Dec 2005 07:43:03 -0800
Lines: 26
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.infopath
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.infopath:25195
X-Tomcat-NG: microsoft.public.infopath

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....

Any ideas?

 

[Butterbull]

Hi

Solved the problem.
On the Win2K server SQLXML 3.0, SOAP Toolkit 2.0 SP2 -> works
On Win2K3 SQLXML 3.0 needs SOAP Toolkit 3.0 installed.

Thanks