I've been struggling with this error for awhile now and I'm hoping someone can help me out with this. I saw another post for this same issue, but it doesn't look like it was answered. My apologies for the long post...
When trying to open a new instance of an InfoPath form I created, I am getting two error messages.
The first error message is:
The file or folder name
'http://server/_layouts/GetDataConnectionFile.aspx?Udc=GetAllOfficeLocations.udcx&Urn=urn:schemas-microsoft-com:office:infopath:ITServiceRequests:-myXSD-2008-01-31T17-03-18&Version=1.0.0.153' contains characters that are not permitted. Enter a different name.
When I hit OK, I get this message next:
This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open.
Here are the details of the second error message:
InfoPath cannot create a new, blank form.
InfoPath cannot open the form. To fix this problem, contact your system administrator.
Form template: http://server/apps/self_service/ITServiceRequests/Forms/template.xsn
The query cannot be run for the following DataObject: GetAllOfficeLocations
InfoPath cannot run the specified query.
Access to the connection file http://service/_layouts/GetDataConnectionFile.aspx is denied.
So what characters are not permitted? And is access denied only because I set up the form to not open if the data connections cannot be queried to populate the drop down lists on the form or do I have a separate issue actually accessing the data connections?
Here is some background info on what I've done so far...
I have an InfoPath form that I am publishing to a server running MOSS and Forms Services. Within the InfoPath form, I have numerous data connections that hook up to web services I wrote running on another server. The web services are configured as data connections within my InfoPath form and some of them are called on form load to populate drop down lists with data from the database. The remaining web services are configured to submit data to the same database when the user submits the form.
I have published the data connections to a Data Connection Library within SharePoint and they have been approved. I did this to avoid the Microsoft Office InfoPath Security message that is displayed each time the form is opened. The first data connection called is GetAllOfficeLocations and here is the XML in SharePoint for that data connection:
<?xml version="1.0" encoding="UTF-8" ?>
<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>
- <udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">
<udc:Name>GetAllOfficeLocations</udc:Name>
<udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: ReadOnly; Generated by Microsoft Office InfoPath 2007 on 2008-02-29 at 16:32:58 by AD\xxxxxxx.</udc:Description>
- <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">
<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />
</udc:Type>
- <udc:ConnectionInfo Purpose="ReadOnly" AltDataSource="">
<udc:WsdlUrl>http://server/MyWebService.asmx?WSDL</udc:WsdlUrl>
<udc:ServiceUrl UseFormsServiceProxy="false">http://server/MyWebService.asmx</udc:ServiceUrl>
<udc:SoapAction>http://server/webservices/GetAllOfficeLocations</udc:SoapAction>
</udc:SelectCommand>
<udc:ServiceUrl UseFormsServiceProxy="false" />
<udc:FileName>Specify a filename or formula</udc:FileName>
<udc:FolderName AllowOverwrite="" />
</udc:UpdateCommand>
- <!-- udc:Authentication><udc:SSO AppId='' CredentialType='' /></udc:Authentication
-->
f(clean);
</udc:ConnectionInfo>
</udc:DataSource>