Connecting to an SQL Server 2005 web service

L

lars

I am trying to connect InfoPath to an SQL server 2005 web service, but
InfoPath is complaining about the WSDL. In the WSDL are two webmethods
mapped to two stored procedures, one with an output and one with and
input parameter of type XML(CONTENT dbo.MySchemaCollection). The WSDL
displays fine in IE if I browse to http://localhost/sql?WSDL and the
schema I have added to dbo.MySchemaCollection is visible within it.
However, when I try to connect to the web service using InfoPath I get
several error messages:

WSDLOperation: The parameters for element parameters in operation
GetMetadata could not be created. The parameters could not be expanded
HRESULT=0x80004005: Unspecified error
- WSDLOperation: Initializing of the input message failed for
operation GetMetadata HRESULT=0x80004005: Unspecified error
- WSDLPort: An operation for port Navet could not be initialized
HRESULT=0x80004005: Unspecified error
- WSDLPort: Analyzing the binding information for port Navet failed
HRESULT=0x80004005: Unspecified error
- WSDLService: Initialization of the port for service Navet failed
HRESULT=0x80004005: Unspecified error
- WSDLReader: Analyzing the WSDL file failed HRESULT=0x80004005:
Unspecified error

GetMetadata is the first of the webmethods and Navet is the name of the
database, as specified in the endpoint. I would really appreciate any
help on this matter, or pointers to other ways to retrieve and store
XML data in SQL Server 2005 with InfoPath. Although I can't see why
using a web service wouldn't work...

Thanks,
Lars Rönnbäck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top