SQL Database Integration

Re: Accessing SQL with infopath issue (permissions?)

ZhenYuan — Fri, 05 Nov 2010 03:52:20 GMT

Hi Patrick,

Sounds like the same issue I faced when I preview the form and my database data shows, when I publish and open the form, the data can't be drawn and there is no error message. I am using a Database data connection to my SQL server.

Are you recommending we use DBXL's web service always? The reason why I am using Database data connection is because I am trying to run a stored procedure using form code but first I have to have a connection to my database for that to happen.

Seem like some permissions issue is stopping me here. Can I achieve the same objectives (running a SP via Visual Basic code) using webservice calls?

Thanks Patrick!

Re: Accessing SQL with infopath issue (permissions?)

Patrick Halstead — Wed, 22 Sep 2010 20:14:38 GMT

You'll need to configure BCS in the form or use a Web Service. The problem is that InfoPath Forms Services (IPFS) is running on the server in the context of the server and the user is accessing the browser in a different context. You could configure IPFS to have total access to the database but that's a security hole. You'll need to look into adding BCS to your form to pull the items through a ShP list or try a generic Web Service like Qdabra's Database Accelerator which can be configured to do this easily.

Accessing SQL with infopath issue (permissions?)

bmcomp — Wed, 22 Sep 2010 13:47:28 GMT

Hi, I have been testing a infopath form to pull data from a SQL database. It works fine except after its been published to sharepoint. My form is not fully trusted. Also i noticed I don't get the normal Security Notice to confirm the data sources. I do get this when previewing, but i have always got this even when data connections are not required on load. So I am assuming my problem is that I am not getting asked to trust the connection so the connection fails. The SQL database and sharepoint are both on the same server. Any idea, how to solve this?