InfoPath Dev

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.

 

Hi DebiScott:

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

Jo-Anne

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

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?

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

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?

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)?

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.

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.