InfoPath Dev

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)

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

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.

 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...

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

 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.

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

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.

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

R.

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?