Re: How to work with SQL stored procedure with InfoPath using SQL webservice

Sohaib Khan — Fri, 29 Oct 2010 10:03:17 GMT

I've resolved this issue by assigning Full Trust in the infopath forms

How to work with SQL stored procedure with InfoPath using SQL webservice

Sohaib Khan — Fri, 29 Oct 2010 08:07:54 GMT

Hi, I've developed a SQL Server based webservice (SOAP)

/****** Object: Endpoint [SQL_Test] Script Date: 10/28/2010 11:22:48 ******/
CREATE ENDPOINT [SQL_Test]
AUTHORIZATION [DOMAIN\user]
STATE=STARTED
AS HTTP (PATH=N'/Test', PORTS = (CLEAR), AUTHENTICATION = (NTLM), SITE=N'xxx.xxx.x.xxx', CLEAR_PORT = xx, COMPRESSION=DISABLED)
FOR SOAP (
WEBMETHOD 'GetCountries'( NAME=N'[TestDatabase].[dbo].[GetCountries]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'TestDatabase', NAMESPACE=N'http://TestDatabase', SCHEMA=STANDARD, CHARACTER_SET=XML)

Then, I created a new Blank InfoPath form. I added my webservice in DataSource. In DataSource, I clicked on field1 drop down and selected Drop Down List. When i try to Preview, it gives me following error:

"The query cannot be run for the following DataObject: GetCountries InfoPath cannot run the specified query. Access is denied."

May i know the reason please ?

Thanks

Web Services

Re: How to work with SQL stored procedure with InfoPath using SQL webservice

How to work with SQL stored procedure with InfoPath using SQL webservice