InfoPath Dev

Hi all,

I have Browser enabled infopath form that get the current user profile via web service from sharepoint user profile that in turn comes from AD,

the solution works fine for a couple of months without any problem,but now I have a problem in which users can submit the form to the form library,but when

 they trying to open the submitted form it gives the following error :

What recent changes have occurred on the server? Sounds like the SP installation might have gotten messed up.

I have installed MOSS service pack1 a month ago,this is the only thing that I have installed before the form start to give errors ,

Please help :)

It doesn't seem likely that SP1 would have caused this unless there was problems during the installation. Please check your system logs to see if there were any problems with the installation. You might try reapplying SP1.

 Take a look at this solution as well.

Hi all,

 I get the same error, 5566 error occurred accessing data source, but only for my test user, SPTest1.  My situation is a little different but essentially the same - I have a custom workflow that uses an InfoPath form to edit the Task.  When user clicks the Task, they get my custom IP form.  The IP form is using the GetUserProfileByName web service using the "no code" method described in a different blog (edit the text box properties, and add a function to the Default Value, Value box, etc).  

None of the posted suggestions has worked to resolve the 5566 error, I've searched high and low on Google, MSDN forums, everywhere.  My other user account is the machine administrator account (virtual machine environment so I can test stuff like this), and it does not get the error.  I'm running MOSS on WinServer 2003, IE7.  If I'm logged in to the machine as administrator, it works.  If I change the user login in IE only, to SPTest1, it fails with the dreaded 5566 error.  If I log on to the machine as SPTest1, it fails no matter which SP user account I log into via the browser, even if I change SP user to my administrator acct., it still fails.  I'm at a loss, don't know where to turn, I've done almost all the things the postings and blogs say to do: turned off anonymous access in Central Admin, bumped up the size and timeout settings in Cent. Admin, my InfoPath form is running with full trust, etc.

Any help is greatly appreciated,

KevinHou

I would suggest you to check the annonymous Access user name of Central admin website is set to iuser_machineNo.

Now make an entry of that userName in Database Login group.

hope this works fine !

same deal for me too!

I have tried all solutions I have been able to find. Google, Live, MSDN, etc.

nothing seems to work.???

An error occurred accessing a data source.

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

Dont suppose anyone has figured out a way to fix this?

yes, at least for me it ended up being a double hop issue.

I fixed this by publishing my web service to one of my web front end SharePoint servers.  I'm sure there are other solutions, but this was a quick way for me to resolve the situation in my environment.

--Adam

Thanks very much for replying, I will try this fix.

Just to follow up from my July posting, I figured out one 'solution', if I make my test user a member of my top level site's Owners group, it works.  The real solution was to change the URL for the web service my InfoPath form is using to get user information out of SharePoint.  In your IP form when you're creating your data connection (mine was to the GetUserProfileByName), set the URL for the path to the web service to a site level that your potential user base will be able to access.  Mine originally was something like http://my-portal/_vti_bin/UserProfileService.asmx?WSDL.   But this would require my users to have the necessary privs to execute this web service from the top level site (when I gave my users full access to one of the root groups they stopped getting the 5566 error, but I don't want them to have that high of access).  Since our users do their work a few sites beneath the site collection, I just changed the URL to match: http://my-portal/site1/subsite2/_vti_bin/UserProfileService.asmx?WSDL.  Re-published, redeployed (See Nick Swan' deployment article at http://weblog.vb-tech.com/nick/archive/2007/03/05/2241.aspx) and the 5566 error went away.  Of course my 5566 was "An error occurred accessing a data source", and this solution fixed that problem.  The trouble with 5566 is that it is a catch-all for other errors, you have to click on the Details link to see what yours is specifically.

 Hoping this helps others,

KevinHou

 u need sso

 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...