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