Browser Forms

Re: Data connection failed on the web form

s42bm — Tue, 17 Aug 2010 17:07:09 GMT

Actually, we tried the method 2 provided on that web site and restarted the server. Yes, there're 401 error in the log file. I copied one of the entries and posted below. 2010-08-17 11:50:30 W3SVC1140986493 142.139.122.31 GET /sites/applications/correspondence/_layouts/listedit.aspx List=%7B007BA382%2D00ED%2D4C64%2DB1EF%2D28463B5B180C%7D 80 - Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+GTB6.5;+InfoPath.2;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.648;+.NET+CLR+3.5.21022;+MS-RTC+LM+8) 401 2 2148074254

Re: Data connection failed on the web form

Potemkine — Tue, 17 Aug 2010 15:35:12 GMT

Can you check your IIS log to see if you have some 401 error?

Can you try this method: http://support.microsoft.com/kb/896861/en-us

Method 1: Specify host names (Preferred method if NTLM authentication is desired)

loadTOCNode(2, 'workaround'); To specify the host names that are mapped to the loopback address and can connect to Web sites on your computer, follow these steps:

Set the DisableStrictNameChecking registry entry to 1. For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:
281308 (http://support.microsoft.com/kb/281308/ ) Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name
Click Start, click Run, type regedit, and then click OK.
In Registry Editor, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
Right-click MSV1_0, point to New, and then click Multi-String Value.
Type BackConnectionHostNames, and then press ENTER.
Right-click BackConnectionHostNames, and then click Modify.
In the Value data box, type the host name or the host names for the sites that are on the local computer, and then click OK.
Quit Registry Editor, and then restart the IISAdmin service.

Re: Data connection failed on the web form

s42bm — Tue, 17 Aug 2010 14:43:26 GMT

No, it's win 2003.

Re: Data connection failed on the web form

Potemkine — Tue, 17 Aug 2010 14:31:32 GMT

Your OS is win 2008 ? I always see some problem with kb926642 It can cause your problem.

Re: Data connection failed on the web form

s42bm — Tue, 17 Aug 2010 13:49:43 GMT

It's MOSS 2007 with 1 wfe. The crawling got some problem recently, does it have something to do with the web form?

Re: Data connection failed on the web form

Potemkine — Tue, 17 Aug 2010 13:21:57 GMT

Yes, another things what is your Sharepoint OS ? The crawling on your server is working fine ? Do you have 2 or more WFE?

Re: Data connection failed on the web form

s42bm — Tue, 17 Aug 2010 12:35:41 GMT

My account has admin privilege. If it doesn't work, it's not likely others would do. Instead of pulling info directly from the list, it requests from a list view by XMLQuery. This may be the cause of the problem. It's hard to diagnose where the problems is when system feedback is not adequate. :(

Re: Data connection failed on the web form

Potemkine — Tue, 17 Aug 2010 12:22:13 GMT

The anonymous access it should not be allowed, so your right. Does this happen for all user accounts? Have you tried it with a different user account ? On a different computer?

Re: Data connection failed on the web form

s42bm — Tue, 17 Aug 2010 12:03:06 GMT

Yes, the server was restarted. Unfortunately, the anonymous access is not allowed.

Re: Data connection failed on the web form

Potemkine — Mon, 16 Aug 2010 20:13:07 GMT

Yes it should work on "domain". Can you check if anonymous acces is checked at WA level ?

(After you add your reg key Have you reboot the computer or iisreset?)

Re: Data connection failed on the web form

s42bm — Mon, 16 Aug 2010 19:49:04 GMT

It doesn't work. Since the dev and production server are in the same domain, is it fine to set security level to "domain"?

Re: Data connection failed on the web form

Potemkine — Mon, 16 Aug 2010 19:15:22 GMT

Your web service is on the root level ? if not try to change your managed path from "Explicit Inclusion" to "Wildcard Inclusion"

Re: Data connection failed on the web form

s42bm — Mon, 16 Aug 2010 18:53:19 GMT

Hi Potemkine, Thanks for the quick reply. I set DisableLoopbackCheck to 1 and still got same error when form's loading. The data connection works fine in InfoPath application, but not for the web form. Do you have any idea about what else it could be? Thanks!

Re: Data connection failed on the web form

Potemkine — Mon, 16 Aug 2010 15:35:33 GMT

hi, can you try to disable loopback check on the server. Check this link:

http://support.microsoft.com/kb/926642

and:

http://www.infopathdev.com/forums/p/7676/50483.aspx

Data connection failed on the web form

s42bm — Mon, 16 Aug 2010 15:07:04 GMT

We have two servers, one dev and one production. When the web form grabs data from a sharepoint list on dev, it's working fine. It failed when the data connection's been pointed to a list on production server. The use of authentication in data connection and cross domain connection are granted in central admin. A .udcx file is created and approved. We still get error when form loads with error code 5566. Does anyone know what possibly wrong or what we should pay attention to when using data connection with web forms? Thanks in advance!