Loading an XML file as a data source from a SharePoint Library.

[Stephen Hynds]

I have some code in a form that loads an XML file as a secondary data
source. The code is:

Dim q As FileQueryConnection =
CType(Me.DataConnections("WorkProgramme"), FileQueryConnection)
q.FileLocation = strPath
q.Execute()

strPath is a string containing the path of the xml file in the format
"http://server/site/documentlib/filename.xml" as the xml file is
located on a SharePoint server. This xml file itself is generated
using another Infopath form.

The code works fine in the client, but when I deploy it to the
SharePoint server and try and run it I get an error telling me that
Infopath cannot open the data source.

To me it seems that it must be a security error, but I cannot see
where the problem can lie.

Does anyone have any ideas?

 

[K.Ramana Reddy(GGK Tech)]

Hi,

What is the security level of your infopath form?

 

[Stephen Hynds]

Hi, thanks for the quick reply. The security level is set to full
trust at the moment. Should I change this to domain trust perhaps?

I was thinking it could perhaps be related to the infopath service on
the SharePoint service. Is this a seperate service from the one that
the website runs under? I have kerberos pass through authentication
enabled and working on all my application pools and services etc. but
didn't know if the Infopath forms ran under their own specific service
account that I've yet to locate.

Cheers

Stephen

 

[Stephen Hynds]

I tried the Domain Trust setting and it also results in the same
error. Anyone got any thoughts?