We have an InfoPath 2007 form that we developed to run as a content type in a SharePoint library. Two of the fields within the form reference SharePoint lists for Project Managers and Project Sponsors. When the form was first published to the library everything worked great. However, updates to the form have occurred and the SharePoint library was moved and since then we have been getting a data connection error every time we open the form.
Here is what I am seeing:
Error Details:
The query cannot be run for the following DataObject: Project Managers
InfoPath cannot run the specified query.
InfoPath either cannot connect to the data source or the service has timed out.
The workaround is to click Try to Connect, which then brings up the next dialog box:
Error Details:
The query cannot be run for the following DataObject: Project Managers
InfoPath cannot run the specified query.
InfoPath either cannot connect to the data source or the service has timed out.
The query cannot be run for the following DataObject: Project Sponsors
InfoPath cannot run the specified query.
InfoPath either cannot connect to the data source or the service has timed out.
So it's telling me that the fields that reference the two SharePoint lists supposedly are not retrieving the data. However, when I make any changes to the SharePoint lists by adding or removing names from the changes are shown in the drop-down in the InfoPath form fields when you open it. So it's actually pulling in the correct data in those fields, yet we still get this error every time the form is opened. I have checked the data connections on both fields and everything is pointing to the correct URL. So I'm not sure why this error or alert comes up.
Any ideas or suggestions??
Thank you for any help you can pr