cutehina


Dear All,

I found an strange warning while accessing the InfoPath form that acquiring some field connection with data source.

The error occur like this:

Warning:

An error occured while accessing the data source

Log ID: 5566

Anybody told me the solution of this problem

Thanks,

Hina.



Re: How to check data source permissions

Kalyan Reddy MVP (GGK Tech)


Hello

It seems to be a permission error. Did you check the permissions to acess the dataconnection

Also read the links below, especially the replies at the bottom of the page.

http://blogs.msdn.com/infopath/archive/2006/06/14/advanced-server-side-authentication-for-data-connections-part-1.aspx

http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx

Hope this gives you an idea.






Re: How to check data source permissions

cutehina

Dear Kalyan,

I am really thankfull for your help.

Actually, my form is publishing without any error, when i use the web service from http://servername/ but not at https://servername.(Showing the same error LogID:5566 and data source connection error).

I delivered the full trust to the form and follow the suggested tutorials for designing and configuration. But the case is still the same. Can you tell me, how to check datasource permission which is working fine with http but not with https or i have to intact digital signature.

Below is the detail of form proceedings after accessing from browser.

1. Go to my Expenses Form Library on MOSS.

2. Click on New -> New Document. The InfoPath Forms Services load (Loading Form...) and then a dialog box appears on the browser that says:

Warning

There has been an error while processing the form.

Click Continue to resume filling out the form. You may want to check your form data for errors.

Click Start Over to load a new copy of the form.

Show error details

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

3. I have two options to click: CONTINUE or START OVER. Clicking on CONTINUE will loop from point 1 to point 3 (this point). That is, the error doesn't go away. By clicking on continue, the form loads, but the field where the employee name should be is empty.

Please help me to solve this problem.

Best Regards,

Hina






Re: How to check data source permissions

cutehina

Dear Kalyan,

I want your concern to resolve this problem. I reviewed your suggestion and make this operation.....

Currently my InfoPath form is opening sucessfully in client mode but not supporting the datasource in browser oriented mode and throughing the message below message highligted in RED. Even though the same form is working fine when i use the datasource with http://servername but not working when i use https://servername.

An error occurred accessing the datasource.

LogID: 5566

Continue Start over

When i click the Continue the form open with data and submitting properly.

What i've done to check this issue:

1) Checked all Infopath services and associated checkes....

2) Checked all logs, but didn't find any exception.

3) Used Full trust to form but the problem is still there with datasource

Please help me to resolve this issue.

Best Regards,

Hina





Re: How to check data source permissions

David Dean

If your data source is defined to call a web service using the http:// protocol, the retrieval will probably fail if you access the published form template via the https:// protocol, because this is seen as being on a different domain. If your form template will be accessed via https, then your web service should also be accessed via https. If this is not possible, then in addition to using Full Trust on your form template you will need to use Central Administration to enable the web service proxy for InfoPath Forms Services.

If your form template needs to be accessible using both http or https, then you may have to modify the data connection URL at runtime using code.

It is possible to use different web service URLs on different sites by using a.udcx file in a Data Connection library to define the web service connection parameters.

  1. On your MOSS site collection, create a new document library using the Data Connection template.
  2. In InfoPath, open the Data Connections window, select the data source, and click the Convert... button.
  3. Save a .udcx file for the web service in the library you created.
  4. To change the web service URL, download the .udcx file, edit it in Notepad, and upload the .udcx file back to the library.
  5. Check in and publish the udcx file.

BTW - If you don't see the error message in the Event Viewer on the server, then check the SharePoint log files. By default, these are stored in the folder "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS".






Re: How to check data source permissions

fuimaypang

hi, i oso face the same problem. Finally i found the solution with it, hope can help u.

1. Open the Central Administration site.

2. In the Central Administration site, click the Application Management tab.

3. Under the Application Security section, click the link titled Authentication Providers.

4. If the correct web application is not already selected, drop down the Web Application selection list and click Change Web Application.

5. On the Authentication Provider page, click the Default Zone link.

6. On the Edit Authentication page, uncheck the box labeled Enable Anonymous Access

7. Click the Save button

Well, done. So now, try to open your form again at WEB.





Re: How to check data source permissions

KevinHou

I am also having this problem - 5566. I've learned that 5566 is like a generic error number, nothing really useful or specific. I've looked at all the latest postings that I can google and checked all the suggestions: full trust, disable anonymous, etc. I've done them all. What I have not done is to create a data access connector and library. The reason is, lucky for me, is that my SharePoint/Infopath solution works fine without a DCL on our production system. We couldn't figure out why my development machine wouldn't work so we just tried on a whim to put it into production - and it works! But my development virtual machine has this 5566 error (My VM is fully setup with Win2003, SP, the works - everything works great except for when I run my Infopath form). It works if I'm logged into my VM as Administrator, but if I login as another user, it fails with this error. I added my test user acct to the Administrators group - no luck. I added 'Everyone' to the Administrators group - no luck. We are using NTLM (Integrated Windows Auth), not Kerberos. Does anyone have any more info on this problem or how to solve it

Thanks a bunch,

Kevin