Data Connections

Re: Cannot connect to data connection in browser

MrsEstrada — Tue, 01 Sep 2009 15:56:46 GMT

I changed the Advanced Settings to allow the form to open in the Client App and it worked as it should. Does this mean it's an issue w/the SSO set up? If so what steps would I need to take to fix it?

Re: Cannot connect to data connection in browser

Jo-Anne Alfafara — Tue, 01 Sep 2009 09:37:27 GMT

Hello and welcome to our forums!

To sort out the problem, could you try opening the form in the SharePoint library using the client application instead of browser and see if the result is different? This will give you a better idea of what could be causing the error, since the problem could be either Form Services or SSO set up.

Cannot connect to data connection in browser

MrsEstrada — Mon, 31 Aug 2009 22:56:20 GMT

I have created a form that uses 4 data connections. 1 is the basic "get user profile" and the other 3 are sql database connections. The latter connections use a "double hop" method but I do have a SSO. I can view the form correctly w/all data connections working properly in preview mode. The problem is that when it's published it cannot connect to the 3 sql database connections in the browser. I get the "Error occured accessing the data source" message for the 3 times (assuming it's referring to the 3 sql connections), and I feel like I'm very close to getting this to work correctly but I'm not sure what to do or where to look to fix the problem. The form will only receive and display data from the 3 sql database connections. Help =)