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.