Re: No data from SQL Web Service data source (works fine in InfoPath client, not in browser)

glenc — Sat, 20 Oct 2007 23:03:07 GMT

Okay - nevermind. I figured it out.

The XML returned from the SQL web service doesn't match the sample schema that InfoPath set up initially. So the data is there, but the XPath doesn't work.

No data from SQL Web Service data source (works fine in InfoPath client, not in browser)

glenc — Sat, 20 Oct 2007 22:43:43 GMT

I have a form that calls a stored procedure in a SQL 2005 database. The stored procedure is exposed via web services (HTTP Endpoints). I am using SharePoint's SSO infrastructure to pass authentication to SQL. When I load my form in the InfoPath client (after publishing it to a doc lib) it works fine. But when I open it in a browser, i don't get any results bound to my control (drop down).

Has anyone experienced this before?

The bizarre thing is that if I write some code in the Form_Loading event, I can see that the data is there. I can pull the OuterXml of the data connection and display it in my form. But the drop down never binds to it. In the same exact form, if I add another data connection bound to a SharePoint list, the data loads successfully. It seems like there is some sort of delay when the server is calling the stored procedure - it's like the form continues rendering and returns to the browser before the data is done loading.

Browser Forms

Re: No data from SQL Web Service data source (works fine in InfoPath client, not in browser)

No data from SQL Web Service data source (works fine in InfoPath client, not in browser)