Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

An InfoPath browser enabled form that has udcx connections from a connection library, code in C# and some rules, was created and tested on the SharePoint server and functions more or less as designed on the server using the SharePoint service account. When testing the form using a regular user's account, the following is shown upon loading the form.

A database that contains data required for this form to function correctly cannot be found.

An entry has been added to the Windows event log of the server. Log ID:5566

The error is repeated five (5) times. In Event Viewer, it shows that there is a DataAdapterException was thrown. After that, the form loads, but a dropdown list that pulls its data from database via a udcx connection shows no options at all in the list.

Permissions settings is the most obvious place to start. The InfoPath form is set to Fully Trusted. The permissions of document library where the form resides has been checked over and over as well as the permissions of the connection library with the udcx files, but the form still gives the same error when accessed as a regular user, but no problems using the SharePoint admin account. When permissions for both libraries were set to Full Control, for all regular users (bad idea, but just to see if it would work) the errors still persists.

Any help and advice in handling the situation are more than welcome.

Thank you all in advance!

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted
  • Ensure the user has rights to access the database
  • Also ensure the connection file has been approved - A sharepoint admin can access a non approved Ucdx file. Go to the connection library and approve the file.
share|improve this answer
    
Before getting to this state, I ensured that the udcx files had been approved. I'll need to double check the database rights though. –  RX3R0 Feb 19 '13 at 14:26
    
User access rights to the database seemed to be the issue. It's now seems to be functional for regular users as it is for the SharePoint admin account. Thank you very much for you help!! –  RX3R0 Feb 19 '13 at 17:27
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.