Error opening form in DBXL - InfoPath Dev
in

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

Error opening form in DBXL

Last post 03-18-2013 02:28 PM by ErnestoM. 9 replies.
Page 1 of 1 (10 items)
Sort Posts: Previous Next
  • 03-05-2013 02:26 PM

    Error opening form in DBXL

    Greetings,


    I created a stub form that has some C# code in the FormCode.cs file for the FormEvents_Loading event.  It runs fine locally (from the designer) but when I try to import it into DBXL by following the getting started with DBXL guide, I start getting the below error.  Wondering if I need to "publish" the file to some package format before going into DBXL?  I am using DBXL version 2.4.3978.28391 and Form version 2.4.0.510.

     My code-behind just uses the AD service from DBXL to look up the current users deparmtent then queries my DB using a secondary DB datasource.

    Thoughts?

    Rob

    Error:

    InfoPath cannot open a new form.
    The form cannot be opened. To fix this problem, contact the form designer.
    Form template: HTTP://Intranet.mydomain.ca/QdabraWebService/Forms/ID/1373/template.xsn
    InfoPath cannot open the selected form because of an error in the form's code.
    One or more required components of InfoPath or the form template cannot run because of a security restriction.
    Contact your system administrator or run Setup again to confirm that .NET Programmability Support is installed on your computer.
    Request for the permission of type 'Microsoft.Office.InfoPath.InfoPathPermission, Microsoft.Office.InfoPath.Client.Internal.Host, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' failed.

       at Microsoft.Office.Interop.InfoPath.SemiTrust.XDocumentsCollectionWrapper.NewFromSolution(Object varURI)
       at AdminTool.Configuration.OpenTemplate(String templateUrl)
       at AdminTool.Configuration.btnOpenNewDocument_OnClick(DocActionEvent e)
       at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

  • 03-05-2013 02:31 PM In reply to

    Re: Error opening form in DBXL

     Hi - Is the DBXL site in your local intranet in IE?

    Hilary Stoupa
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 03-05-2013 02:37 PM In reply to

    Re: Error opening form in DBXL

    Just to confirm, you mean if I look in...

    IE -> Tools -> Internet Options -> Security Tab -> Local intranet -> Sites -> Advanced?

    I have http://*.mydomain.ca in my list if you do.   Will this work with the *. wildcard? 

    R.

  • 03-05-2013 02:46 PM In reply to

    Re: Error opening form in DBXL

     Yes, that's what I meant - sorry to have been so oblique. Are you opening this on the same machine you did the dev work on? I've had this error when the DBXL site wasn't in my local intranet (wildcard should be fine) or on machines where .NET support wasn't installed with IP...

    Hilary Stoupa
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 03-05-2013 03:05 PM In reply to

    Re: Error opening form in DBXL

    No worries, not oblique at all.  I just wanted to make sure I wasn't misinterpreting :).  I am running it from my local workstation where I developed the form.  When I added it into DBXL I just upload the .xsn form vs. some sort of publish to include the code-behind.  I havn't come across any special documentation on how to insert Forms that have code-behind... if there are special steps, I may have missed?

    Thx,

    Robin

  • 03-05-2013 03:22 PM In reply to

    Re: Error opening form in DBXL

     Well, your form will include the code DLL, so you don't need to do anything special for that. Is your form full trust or domain trust? I know for Full Trust (signed) forms there are special steps for the DAT document type, but for domain trust, you should be able to just attach the template.

    Hilary Stoupa
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 03-06-2013 06:17 AM In reply to

    Re: Error opening form in DBXL

    I manually selected domain trust and re-published but it still gives the error.

  • 03-06-2013 03:18 PM In reply to

    Re: Error opening form in DBXL

    I'm honestly not sure what could be going on here.

    Full trust forms do require some extra config steps (http://www.infopathdev.com/files/folders/other_subjects/entry74138.aspx), but the error you're getting leads me to some of Hilary's same thoughts about the Internet Explorer settings.

    I think there are a couple of options:

    1. Contact us via support at qdabra dot com and we'll try to troubleshoot this.
    2. Look at what the form is doing in the code and see if we can mimic that in a codeless way.

    DBXL has an Active Directory Web Service which would allow us to obtain the value of any key (e.g. Department) and DBXL also has the QueryDB web service which would allow querying the database to obtain some data. If you'd like to pursue the codeless option, let us know.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 03-15-2013 08:02 AM In reply to

    Re: Error opening form in DBXL

    Thanks Ernesto/Hilary.  I've submitted a support email.

    R.

  • 03-18-2013 02:28 PM In reply to

    Re: Error opening form in DBXL

    RobSil1976:

    Just to confirm, you mean if I look in...

    IE -> Tools -> Internet Options -> Security Tab -> Local intranet -> Sites -> Advanced?

    I have http://*.mydomain.ca in my list if you do.   Will this work with the *. wildcard? 

    R.

    Can you try without the wildcard?

    Make sure to use the same URL as is being used with DBXL, for example, if DBXL is on

    http://server.mydomain.ca/qdabrawebservice

    Then in Local Intranet you should have

    http://server.mydomain.ca

    The error really suggests some sort of machine issue. Do you have any computer from which to test?

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (10 items)
Copyright © 2003-2012 Qdabra Software. All rights reserved.
View our Terms of Use.