Hello all,
I have a webservice which i have deployed to sharepoint layouts folder and i access it through http://test/_layouts/mywebservice.asmx..now i have a form which has this web service as secondary data connection and what this web service does is that it gets data from sql server which is on a different server..now i convert this data connection to udcx file and then i publish my form to http://test...but when i open thr form in browser i get the below error.it might be a common issue but i am not able to identify what the problem is ..if somebody can guide me then it would really be a great help.
An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID: 5566
The sharepoint log files record the following
07/14/2010 16:45:22.25 w3wp.exe (0x5FB0)
0x0958 Forms Server
Forms Services Data Objects 13zh Exception
System.Net.WebException:
The remote server returned an error: (401) Unauthorized. at
System.Net.HttpWebRequest.GetResponse() at
Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest
request, DataAdapterTimer dataAdapterTimer, DataAdapterCredentials
credentials, Stopwatch timer, ExecWebRequestExceptionState state, String
adapterName,
Boolean isQuery) at
Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator
inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM,
Boolean resultUseDataset, XPathNavigator
errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec,
Solution solution, Document document, String name, Boolean isQuery,
DataAdapterTimer dataAdapterTimer, DataAd...
1bf84c81-cb50-4514-85a9-a20b4a9d7b08
07/14/2010 16:45:22.25* w3wp.exe (0x5FB0)
0x0958 Forms Server
Forms Services Data Objects 13zh Exception
...apterCredentials credentials, Boolean useDcl, Boolean useProxy,
Boolean useSelf) 1bf84c81-cb50-4514-85a9-a20b4a9d7b08
07/14/2010 16:45:22.25 w3wp.exe (0x5FB0)
0x0958 Forms Server
Forms Services Data Objects 7tfk Medium Data adapter
failed during OnLoad: The remote server returned an error: (401)
Unauthorized. 1bf84c81-cb50-4514-85a9-a20b4a9d7b08
07/14/2010 16:45:22.25 w3wp.exe (0x5FB0)
0x0958 Forms Server
Forms Services Runtime - Data C 82fy Warning The
following query failed: employees (User: test\testuser, Form Name:
testForm, IP: , Request:
http://test/_layouts/FormServer.aspx?XsnLocation=http://test/FormServerTemplates/testForm.xsn&SaveLocation=http://test/test+Forms&Source=http://test/test%2520Forms/Forms/AllItems.aspx&DefaultItemOpen=1,
Form ID:
urn:schemas-microsoft-com:office:infopath:SLOForm:-myXSD-2010-04-17T19-29-38,
Type: DataAdapterException, Exception Message: The remote server
returned an error: (401) Unauthorized. The remote server returned an
error: (401) Unauthorized.)
1bf84c81-cb50-4514-85a9-a20b4a9d7b08