Qdabra qRules

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

Hilary Stoupa — Mon, 26 Mar 2012 23:47:27 GMT

And you've tried publishing to a new library as well? Just in case? Do you get any additional info about why the form won't be accessible in the browser now that you are publishing a form you have the source code to?

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Mon, 26 Mar 2012 23:41:22 GMT

I am a site collection admin, I checked that just to make sure.

Thanks for clarifying the process on publishing too.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

Hilary Stoupa — Mon, 26 Mar 2012 23:35:20 GMT

Yup, that should be correct for trying to Sandbox - so it appears either the sandbox is not configured correctly, or that you are not a site collection admin.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Mon, 26 Mar 2012 23:32:11 GMT

publishing to the sandbox I think.

I'm selecting the File>Publish>SharePoint Server

Enter the path to the SharePoint,

Enable this form be filled out by using a browser

Form Library is Checked

Upldate to an existing library

Final screen of the wizard has this

Form library "name of library'

Location: "path to library'

Server Type: InfoPath Forms Services'

Security Level "Domain"

Is this the correct method?

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

Hilary Stoupa — Mon, 26 Mar 2012 23:21:40 GMT

What does "publish to the share" mean - are you publishing as an admin approved template? Or are you trying to sandbox?

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Mon, 26 Mar 2012 23:17:25 GMT

OK, got it working in preview mode.

But I still get an error when trying to publish to the share, about it only being able to opened in filler.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

Hilary Stoupa — Mon, 26 Mar 2012 23:05:49 GMT

Under the Developer tab on the ribbon, select Language.
Click the Remove Code to remove your current code.
Make sure the language is set to C#.
Click OK to close the dialog.
Under the Developer tab on the ribbon, click Loading Event.
Wait for the code editor to open.
The loading event will look like this:

public void FormEvents_Loading(object sender, LoadingEventArgs e)
{
// Write your code here.
}

Where you see // Write your code here, paste the following line:

MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:field1", NamespaceManager).SetValue("Hello there!");

Preview your form.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Mon, 26 Mar 2012 22:56:59 GMT

I must be doing something wrong,

If I copy/paste that code into my form, I get an error that says there are 'build errors' and then it won't even start the publishing wizard to let me put the path to my SP site.

Does the code need to go in a certain spot?

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

Hilary Stoupa — Mon, 26 Mar 2012 22:49:23 GMT

Yes. In C# at least, Visual Studio highlights strings in a red tone. Please see the attached screenshot. I'm assuming you get an error because the code won't compile? Did you set the form to use VB or C#? The reason we provided you with a sample with code was so you could easily try to publish to see if you had an issue with your IPFS configuration.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Mon, 26 Mar 2012 22:40:10 GMT

I should leave the quotes right?

I get an error when trying to preview using this code, I have a field named field1 but in VBA it shows the stuff in the quotes in RED.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

Hilary Stoupa — Mon, 26 Mar 2012 22:22:46 GMT

Hi - I added a simple loading event:

        public void FormEvents_Loading(object sender, LoadingEventArgs e)
        {
            MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:field1", NamespaceManager).SetValue("Hello there!");
        }

You should be able to remove the code currently in the form, and then add the code yourself, if you like. Or create a new form, add a field called "field1", add a loading event and add the code.

If you preveiw the form, you should see the field getting set to Hello there.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Mon, 26 Mar 2012 22:12:13 GMT

Hi,

What was the code that you added to this sample form?

It would not publish for me, and I'm working with our support team, but they are asking me what code is in the form.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

ErnestoM — Thu, 22 Mar 2012 18:52:29 GMT

Hi-

Here's a simple form with code.

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

illegal_operation — Thu, 22 Mar 2012 18:44:58 GMT

I can try #2 really quick, what type of custom code should I add and where?

Thanks!

Re: publishing error 'data connection contains pararmeterized queries' and 'could not verify the form template on the specified server

ErnestoM — Thu, 22 Mar 2012 18:32:42 GMT

More info: The second option would confirm whether you are able to sandbox, i.e. whether you are a site collection admin.