SQL Database Integration

Re: Pulling Data from SQL 2008 into Infopath 2010

Patrick Halstead — Sun, 17 Feb 2013 20:05:21 GMT

Hi Debi,

Not necessarily. If the form is opening in the browser, you can configure a UDCx file (universal data connection) to login to a separate server but it will require hardcoding the credentials in the UDCx which is not a good security practice.

I recommend using our ultra cheap Web service (DBXL). The Beginner license lets you query SQL and it's super fast and very flexible.

Give me a ring and I'd be happy to show you a demo.

Re: Pulling Data from SQL 2008 into Infopath 2010

smithringers10 — Sat, 02 Jun 2012 00:04:55 GMT

I have created a form with 2 fields - one Text field that when filled runs a query by rule to get data from a SQL server and place it in the other field.

Re: Pulling Data from SQL 2008 into Infopath 2010

DebiScott — Tue, 01 May 2012 14:10:18 GMT

So to verify what you are saying - if I have a form published to a sharepoint site that need to pull SQL data from a seperate server I need to have it full trust (Digitally signed)?

Re: Pulling Data from SQL 2008 into Infopath 2010

Jo-Anne Alfafara — Tue, 01 May 2012 05:04:46 GMT

It may be that your form is trying to talk to a service in a different domain and it can't trust it. Have you tried changing the form to full trust?

Re: Pulling Data from SQL 2008 into Infopath 2010

DebiScott — Mon, 30 Apr 2012 15:04:25 GMT

Yes - I have published it to a sharepoint site and am pulling my SQL data from a seperate server

Re: Pulling Data from SQL 2008 into Infopath 2010

Jo-Anne Alfafara — Mon, 30 Apr 2012 00:59:53 GMT

I don't think you need admin approval for this. Perhaps a cross domain issue? Are you publishing the form to a site, say, http://abc.com and trying to query to SQL that is hosted in a different server?

Re: Pulling Data from SQL 2008 into Infopath 2010

DebiScott — Fri, 27 Apr 2012 13:45:00 GMT

I did approve it and I do not have code - thanks Jo-Anne

Re: Pulling Data from SQL 2008 into Infopath 2010

Jo-Anne Alfafara — Fri, 27 Apr 2012 13:26:36 GMT

Hi DebiScott:

Just to rule out, did you approve the UDCX in the SharePoint site? Do you have code in your form?

Jo-Anne

Pulling Data from SQL 2008 into Infopath 2010

DebiScott — Wed, 25 Apr 2012 20:51:20 GMT

I have tried using various connections and admin approving my template all to no avail, I keep getting errors. So I have started over with the following -

1. I have created a form with 2 fields - one Text field that when filled runs a query by rule to get data from a SQL server and place it in the other field.

2. I added a UDCX source that is in my DataConnections database on the site.

3. I can retrieve the data from preview in Infopath (the form .xsn is saved on the Sharepint server) but not within the browser once it is published.

error =

An error occurred querying a data source.

Click OK to resume filling out the form. You may want to check your form data for errors.

If someone could please give me step by step that will get me to be able to query SQL data from my Infopath form I would really appreciate it.