Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / December 2005

Tip: Looking for answers? Try searching our database.

SQLXML Webservice Parameters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Butterbull - 05 Dec 2005 15:43 GMT
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] - 06 Dec 2005 00:35 GMT
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==?=" <Butterbull@discussions.microsoft.com>
Subject: SQLXML Webservice Parameters
Date: Mon, 5 Dec 2005 07:43:03 -0800
Lines: 26
Message-ID: <4D1245A6-CDBA-4FEA-ADBC-18D452E4BFB2@microsoft.com>
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 - 06 Dec 2005 14:57 GMT
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

> Hi,
> Check if webservice is runnning outside IP; check if you are passing
[quoted text clipped - 59 lines]
>
> Any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.