The root of the problem is that my computer is not on the same domain as the SharePoint server. This means that my InfoPath form will not establish a full trust with the server and therefore be unable to retrieve the data it needs. Once the form is published onto the site it resides on the same domain and this problem is eliminated. But man is it annoying when I am trying to test a form.
The solution is pretty simple...
- First create a Data Connection Library somewhere universally accessible to form users on your site.
- Goto Site Actions>More Options and then find the Data Connection Library.
- Name the data connection library what you like; you will be using it to house the file we will end up generating for our cross-domain data connection.
- Now go into MS InfoPath and make your data connection. If you don't know how to make a data connection then chances are you probably won't be reading this post...
- Once the data connection has been made to your target list or library go back into the Data Connection menu.
- Highlight your target data connection and then click "Convert to connection file".
- You will then be prompted to save this new connection file.
- Go ahead and save it into the Data Connection Library you created in the first step of this post.
If your other lists are on the same site you shouldn't need to convert their data connections; this converted connection should do the trick. I am not sure about using a different site/sub-site on the same site collection. If for some reason a different site still won't load, then just repeat these instructions!
I hope this proves to be helpful. This same method can be used for forms that are commonly distributed via email and not published to a single location on the domain.