Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 655
  • Last Modified:

web enabled infopath form not able to fetch the data from SQL Server

I have created a web enabled infopath form.
Now my form has a drop down box which gets the data from the SQL Server to fill.
This form is published on the sharepoint site.

When i run this form with in the infopath client it works fine but when i try to run from my sharepoint site it doesn't get the data instead gives the error.
---------------------------------------------
An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.
Log ID:6932
----------------------------------------------

i read online and tried various options but still not able to make it working. I created the UDC file and upload that in the DLC and tried connecting it that way but still doesn't work for me.

please suggest the best possible solution.
0
vaijain
Asked:
vaijain
  • 2
  • 2
2 Solutions
 
clayfoxCommented:
For a browser based form you must use a UDC.

In the designer use the convert button on the data connection and make sure the UDC works that way.

The other problem you can run into is that if the SQL is not on the same server as Sharepoint the permissions do not get passed correctly. Since InfoPath Form Services is actually hosting the form it does not send your credentials to external servers correctly.

This is a known issues with IIS called "double hop"  you can research this term to find more info.

www.infopathdev.com is a good resource.
0
 
vaijainAuthor Commented:

Let me give you a better picture of the SharePoint Set.
I have 3 server (Application Server, Web Server and SQL Server)

So yes, SQL Server is not on the same server as Share Point (is it called as cross domain?). All though the SQL server is with in the company domain (network).

Now I have tried UDC file ... is it mandatory to provide any kinda credentials to be passed in UDC and if yes then in which tag of the UDC?
0
 
clayfoxCommented:
Yes you have to setup cross domain if it is not in the same IIS site.
Or you need to not secure the data but put the security in the form.
Or you need kerberos I beleive will jump across.
0
 
vaijainAuthor Commented:
So, If i have to use the cross domain method to connect to the SQL Server... what are the steps?
Can you send me some link which can give me some step by step process of doing so.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now