Solved

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

Posted on 2008-10-22
5
653 Views
Last Modified: 2012-08-13
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
Comment
Question by:vaijain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 22785768
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
 

Author Comment

by:vaijain
ID: 22786082

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
 
LVL 28

Assisted Solution

by:clayfox
clayfox earned 500 total points
ID: 22801511
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
 

Author Comment

by:vaijain
ID: 22897087
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question