Data connection failed on the web form - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Data connection failed on the web form

Last post 08-17-2010 10:07 AM by s42bm. 14 replies.
Page 1 of 1 (15 items)
Sort Posts: Previous Next
  • 08-16-2010 08:07 AM

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Data connection failed on the web form

    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!
  • 08-16-2010 08:35 AM In reply to

    Re: Data connection failed on the web form

    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

  • 08-16-2010 11:53 AM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    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!
  • 08-16-2010 12:15 PM In reply to

    Re: Data connection failed on the web form

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

  • 08-16-2010 12:49 PM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    It doesn't work. Since the dev and production server are in the same domain, is it fine to set security level to "domain"?
  • 08-16-2010 01:13 PM In reply to

    Re: Data connection failed on the web form

    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?)

  • 08-17-2010 05:03 AM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    Yes, the server was restarted. Unfortunately, the anonymous access is not allowed.
  • 08-17-2010 05:22 AM In reply to

    Re: Data connection failed on the web form

    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?
  • 08-17-2010 05:35 AM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    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. :(
  • 08-17-2010 06:21 AM In reply to

    Re: Data connection failed on the web form

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

  • 08-17-2010 06:49 AM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    It's MOSS 2007 with 1 wfe. The crawling got some problem recently, does it have something to do with the web form?
  • 08-17-2010 07:31 AM In reply to

    Re: Data connection failed on the web form

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

  • 08-17-2010 07:43 AM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    No, it's win 2003.
  • 08-17-2010 08:35 AM In reply to

    Re: Data connection failed on the web form

    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:

    1. 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
    2. Click Start, click Run, type regedit, and then click OK.
    3. In Registry Editor, locate and then click the following registry key:
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
    4. Right-click MSV1_0, point to New, and then click Multi-String Value.
    5. Type BackConnectionHostNames, and then press ENTER.
    6. Right-click BackConnectionHostNames, and then click Modify.
    7. 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.
    8. Quit Registry Editor, and then restart the IISAdmin service.
  • 08-17-2010 10:07 AM In reply to

    • s42bm
    • Top 500 Contributor
    • Joined on 04-21-2008
    • Posts 32

    Re: Data connection failed on the web form

    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
Page 1 of 1 (15 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.