InfoPath Dev

I have a form with code - simple code to print, submit and close the form.  (No qRules or DBXL is used on this form).

It retrieves data from SharePoint libraries and from a databases, and submits to SharePoint library.

I've been publishing it in full trust because it won't load secondary data sources as a new form if I don't.  I've learned that it is never good to publish a form with full trust, so I switched it to domain and the form won't open.

Why won't domain level trust work in this case?  What am I missing?  Is my only option to use full trust?

Hi Doreen,

Please email us for quicker response since sometimes we don't get to the forum until the weekend. :)

So long as the SharePoint libraries are on the same site, you don't need full trust.

If you are querying a database, why not just use DBXL's QueryDB? Then, you have a Web service and it's a piece of cake to dynamically query and it's domain trust.

If you insist on going the database query with the stock InfoPath data connection, and you are using the browser, please try to convert it to a UDCX and then change the UDCX credentials to specify a user who can access the DB. So long as the database is on the same server, it should work, but you may have to configure SSO credentials if its on a separate server.

If it's filler form, you shouldn't need full trust for any of this.

Need some more info, but rest assured, you should exit the forest with bread crumbs to spare shortly.

Thank you Patrick.  I was in no hurry as I was just trying to understand why/when full trust was required.  You answered my question - and gave me some good ideas too that I will try.

Thank you again.