InfoPath Dev

Hello,

I have created a SQL EndPoint for a Stored Procedure that returns the products based on a criteria parameter; with the data connection added to the InfoPath form this works a treat. However this form must be browser based within InfoPath Form Services. To avoid the Access Denied issue the data connection was converted to a UDCX and stored within the SP site collection and the form published. I am getting no errors but I am also getting no rows returned from the search. I tested the form within the InfoPath client and it is still working. I have tried publishing the form with full trust and customising the UDCX authentication to NTLM but still nothing. I presume that the credentials are being lost between the InfoPath Forms Services form and the SQL endpoint and thus I should use the SharePoint Web Service Proxy however I haven't found a great deal on this yet.

Has anybody succesfully retrieved and displayed data from a SQL EndPoint within InfoPath Form Services or is there a fundamental problem with this approach.

I am running SQL 2005 SP2, MOSS 2007 SP1, InfoPath 2007 SP1

Any assistance would be appreciated.

Hey Tim.

This is usually referred to as a "Double hop" issue in IIS.  The credentials cannot be forwarded to the second site.

You would need the data on the same server as SP or be able to pass a static service account but then you are right IPFS gets cranky.

Have you looked at Qdabra's web service suite? They are generic, reusable, no code, and can be installed on the SP site but access another SQL server.

Might be an option.