We are using lot of InfoPath data connection .udcx files for populating the drop down boxes used in the InfoPath forms. During one of the deployment we found that the changes made in the connection string was not getting updated and the InfoPath forms were keep throwing the errors.
While trouble shooting the issue we found that the Approval status of the Data connection files were showing the pending status. We made the files approve and the InfoPath forms were able to take the latest changes from the .Udcx files.(Publishing features were activated in our site)
We found that there is a way to make the .Udcx connections working even with the "Pending" status. We should modify the logged in user's permission level to have the "Approve" access in the Site Settings-->Advanced Permission --> Settings -->Permission Levels-->[permission level name (for eg contribute)
_526_525.jpg)
