InfoPath browser in MOSS: error occurred accessing a data source

[FranckS]

Hi,
I've created a simple InfoPath form with a drop-down getting data out of a
SQL DB. The data source has been published in a DCL on a site in MOSS.
The form works fine when opened using the rich client but when I try to open
its browser-based version (after publishing it to a Sharepoint site form
library), I always got the following error:

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID:6932

The problem is that there's no entry in the event log.
As my MOSS/IFS server is separate from my DB server, I've configured
Kerberos to avoid the double-hop issue but to no avail.

Any idea where I should look at?

Thanks

 

[S.Y.M. Wong-A-Ton]

I think you're right to assume that it has to do with either a permission or
authentication issue. Here are a few suggestions: Check the SharePoint log
files (C:\Program Files\Common Files\Microsoft Shared\web server
extensions\12\LOGS) for any exceptions. Try giving the form full trust (by
digitally signing it with a certificate) and see whether it helps.

Let me know how it goes; it's not only an interesting problem, but a common
one.

 

[Rajiv Ranjan Giri]

I have used digital certificate and trusted connection but still problem is there and it is:

when you publish this form on a SharePoint (MOSS 2007) server and tries to use it, it gives you an error. The same form worked without any issues before.

1. Go to my 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


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Avinash Dad]

Hi,

I am also getting same error. Please share the solution of this problem.
It would be great help for me.

Thanks a lot
Avinash Dad

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Per Lofbom]

Hi read Your reply to the above mentioned problem but I can't find a solution for it anywhere. Did You get a reply elsewhere I can share?

Best Regards
Per Löfbom

 

[Per Lofbom]

I too experience the same problem. Did You get a solution for it. Please share this with me if You can
Best Regards
Per

 

[Muruga Boopathy]

Hi,

As mentioned earlier, the issues with site permission.

I have a development PC logged as domain\Developer0977. This PC has Info path and Designer 2007. I created a form (sort of approval form) and published to MOSS SharePoint site. Published URL is opened from my PC it works well.

I logged into MOSS Server ( using server admin login - domain\serveradmin ) and opened the URL, I got the following error:
-------------------------------------------------
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
----------------------------------------------------

Logged as domain\Developer0977 in the server and opened the URL, it works well no issues.

Grand user permission to this site and can be accessible over network without any issue.

Reg
Boo

 

[C M]

All solutions mentioned above did not work for me, the following did.

I have got the same error (ID 5566) accessing a datasource list within the same site collection. It worked fine when the dependant dropdown-list was based on a custom list at the root level site. But when it was created at another level, the problems started. When I changed my managed path from "Explicit Inclusion" to "Wildcard Inclusion" everything started working.

Maybe someone can explain this to me...

 

[arvin harinarain]

I have experienced the same problem when populating a drop down from SQL in infopath. When adding the datasource to infopath use a SQL authentication account with dbRead (user name and password sent as plain text so min sercurity permissions is recommended) access to the database.when using windows authentication it fails from a client machine.

N.B also set the options for infopath in central admin to use embedded sql connection.



Franck wrote:

InfoPath browser in MOSS: error occurred accessing a data source
27-Apr-07

Hi
I've created a simple InfoPath form with a drop-down getting data out of a
SQL DB. The data source has been published in a DCL on a site in MOSS
The form works fine when opened using the rich client but when I try to open
its browser-based version (after publishing it to a Sharepoint site form
library), I always got the following error

An error occurred accessing a data source
An entry has been added to the Windows event log of the server.
Log ID:693

The problem is that there's no entry in the event log.
As my MOSS/IFS server is separate from my DB server, I've configured
Kerberos to avoid the double-hop issue but to no avail

Any idea where I should look at

Thank

--
Franck

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Programming C#
http://www.eggheadcafe.com/tutorials/aspnet/718b8580-cd75-4234-8764-db65bebbe8ad/programming-c.aspx