While testing for our transfer from XP to 7, I came across a problem.
If I open a new form from Sharepoint in Windows 7, I get error messages that it cannot connect to my data connections that are windows server databases. I run queries on these databases using VB in the loading event.
However, if I go to design the form and not adjust anything and click preview, everything works fine. So then I thought maybe I just need to save the form from Windows 7, I created a test Form Library on Sharepoint and published my form there and it still fails with the data connection issue as above.
Does anyone have some insight as to how I can fix this?
Error given:
The query cannot be run for the following DataObject: EMPLOYEE_VW
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.