InfoPath Dev

Hi,

 I have created the Infopath which is connected to the webservice for data display and update.

After publishing the infopath into sharepoint. i am getting "An error occurred accessing a data source." in the browser.

Can you help to solve this problem.

Thanks,

Hi 

1. First make sure the user has sufficient permission to access the database/web service.
2. In infopath ->Tools ->Form Options ->Security and trust ->Uncheck “Automatically determine security level” (If database/webservice is on same domain then select domain else select proper option)
3. Convert your data connection in udcx file.
For this, create a data connection library in MOSS.
Now open infopath form -> tools->Data connections
Select data connection and click on “Convert… “ button.
Give data connection library url with file name.
4. Now open Data Connection Library and Right click on udcx file -> "Approve/Reject" -> Select Approve and click OK.
5. Goto Central Administration ->Application Management->configure infopath form services->
“Allow user form templates to use authentication information contained in data connection files” option must be checked.
If your database/web service is placed on another domain then you need to check next option “Allow cross-domain data access for user form templates that use connection settings in a data connection file”.

Hi Madhuri,

 I did the same what yu said. but still i am getting error:

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID:6932

Hi

Try by removing the existing data connection and readd the dataconnection and then publish it to sharepoint library.

Thanks  Madhuri... It is working fine.. :)

Hi

Recently, i had received this error using InfoPath Form published in a MOSS NLB to access an external Web Service.

I configured MOSS to use Kerberos Delegation (using setspn.exe to register Service Principal Names, modifing the IIS MetaBase, an enabling Kerberos Delegation in Application Pool account and computer accounts at Active Directory), and finally works fine.

The problem was that this MOSS Farm scenario contains two Front Server in NLB, so Kerberos Delegation only was working when accesing MOSS using the real computer names (NetBIOS names), but configuring Kerberos Delegation properly, was possible Kerberos Delegation works using the DNS name configured in NLB.

I had detailed this trouble at: 

Configurar MOSS 2007 para invocar un Web Service desde un Formulario InfoPath en NLB 

Regards,

GuilleSQL

Hi,

I too am having trouble with this.  I've created a infopath form where I'm using the Qdabra AD Web Service to populate the user's name.  The form was published to SharePoint and when I open the form in a browser I get the error message "An error occured accessing a data source".  I tried the steps provided by madhuri, but I still get the error.  Anyone have a recommendation?

Does the error message tell you which data source created the error?

It's most likely a permissions issue. You'll need to check on whether your user is authorized to call the web service.

I'm only using one data connection.  The active directory web service is installed on the front end sharepoint servers.  How can I verify who is authorized to call the web service?

Well, I went to the File Security tab for the web service in IIS Manager and under the Authentication and acccess control section checked Enable anonymous access.  That got rid of my error message, but my information is not being populated from the web service.  I can preview my form in Infopath and it populates correctly, but I get nothing when opening the form in a browser.  Any ideas?

 I am coming across this same error now. My form was working correctly for a very long time and just recently I've been having this issue. I tried re-publishing the form thinking that, that may work but of course it didn't and none of my forms are opening anymore. Nothing has been changed on the server (no upgrades or changes to permissions) and the data connection is working fine in the application but not in the browser and no changes have been made to any browser settings. Any thoughts on what I could check? I've run out of options. Your time is appreciated.