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!