Can not create / open a new/blank form

[rgshelto]

I am using SQL Express DB. Designed a form using main connection and several
secondary connections to populate drop downs. Form functions in all respects
in preview but fails when attempting to create a new form.

Details of message:
The following DataObject either cannot be created or cannot be initialized:
MILog Programs
The query cannot be run for the following DataObject: MILog Programs
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Safety settings on this computer prohibit accessing a data source on another
domain."

I made sure that my internet security settings allow accessing data sources
in other domains was enabled. I don't know if this is limitation of
SQLEXpress, if so why does Express allow Preview to work?

Suggestions?

 

[Uma Karnati]

Hi Ron Shelton,

I understood your problem, based on the given error message description.
Actually the problem which you are facing is because of the InfoPath but not
about the SQLExpress. And as you have the doubt regarding why does
InfoPath(not the Express) allow preview to work? Means where you designed
your InfoPath form and preview it with main & secondary data sources are
local data sources at that time for that system.
But when you fill out the same form from a WSS site with same data souses
will become as External data sources(Resources) for the InfoPath form on that
site (ie. which is at different domain system).So, InfoPath will not allow us
to access "external Data sources" with normal security levels.
To do it in InfoPath one way is to include "full trust" for your InfoPath
form.
And see the given below link to solve your problem.
http://office.microsoft.com/en-us/assistance/HP010967191033.aspx