Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2004

Tip: Looking for answers? Try searching our database.

Cannot run ActiveX objects in Trusted Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Installing W2003 on BM Infinity 4500R - 29 Sep 2004 06:05 GMT
The Situation:

We have developed a workflow application whose main components are: Infopath
forms for data entry into an Access database (later to be SQL Server) and MS
Word documents for displaying results. In between these two MS apps we have
developed a proprietary app based on VB.NET.  The Infopath documents and MS
Word documents are published to Sharepoint Services for dissemination to
Intranet users.

The Infopath form has several cascading dropdowns. I use secondary data
sources to populate the dropdown. Jscript code behind is used to filter the
child dropdowns according to choises in the parent dropdown. Jscript
procedures perfom also various data checking.

Jcript is used also to write routines that directly read database tables and
write to database tables using ActiveX Objects. The code I use is simple:

// Connect to the Sentinel Database
var strDbPath = "\\" + "\\" + "Sharepoint1\\MSDatabase\\Sentinel040214.mdb";
var ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
strDbPath;

adoCn = new ActiveXObject("ADODB.Connection");
adoCn.Open (ConnectString);

Finally, I have followd all instructions to publish the Infopath form as a
fully trusted form.

Now the Problem:

1. When I open the Infopath Form the jscript code runs correctly until it
reaches the adoCn.Open (ConnectString) command.

2, The error message is:
"Safety settings on this computer prohibit accessing a data source on
another domain.

File:script.js

Line:557"

Conclusions:
1. If I comment out all references to ActiveX objects, the form runs correctly
2. I have verified that the form runs as a fully trusted form. The
left-bottom corner of the screen displays a small green checkmark. Hovering
over displays "fully trusted form"
3. I have lowered the Security setting of Trusted Sites in IE at the server
to "Low"
3. All documentation I have read tells me that the form containing ActiveX
documents should run as a fully trusted form. Obviously this is not working
in my case.

What am I doing wrong? Is there anything in addition to setting the form as
a fully trusted form that would permit to run ActiveX objects?

Any help on the matter will be higly appreciated. We are rapidly  reaching
deadline time and we are floundering
Steve van Dongen [MSFT] - 29 Sep 2004 18:02 GMT
"Installing W2003 on BM Infinity 4500R"
<InstallingW2003onBMInfinity4500R@discussions.microsoft.com> wrote:

>The Situation:
>
[quoted text clipped - 53 lines]
>Any help on the matter will be higly appreciated. We are rapidly  reaching
>deadline time and we are floundering

See #3
http://groups.google.com/groups?selm=ndanov4oolhih4i11qcvhrtllpi5mu548u%404ax.com

Regards,
Steve
--
Please post questions to the newsgroup; everyone benefits.
This post is provided "AS IS" with no warranties, and confers no rights
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Installing W2003 on BM Infinity 4500R - 30 Sep 2004 05:21 GMT
Thank you, Steve:

I managed to successfully define an ADO connection in a trusted form.
However, I now need the Trusted-Form equivalent to and ADO Command, namely:

var cmd = new ActiveXObject("ADODB.Command");

I need this command to write to a table in the database. I shall appreciate
your help on this matter

As a final request, where can find a complete list of trusted-form ActiveX
objects? I feel I will need to master this list if I am to develop InfoPath
forms of any complexity at all.

Thanks

Jose

> "Installing W2003 on BM Infinity 4500R"
> <InstallingW2003onBMInfinity4500R@discussions.microsoft.com> wrote:
[quoted text clipped - 66 lines]
> This post is provided "AS IS" with no warranties, and confers no rights
> Sample code subject to http://www.microsoft.com/info/cpyright.htm
Steve van Dongen [MSFT] - 01 Oct 2004 21:48 GMT
On Wed, 29 Sep 2004 21:21:02 -0700, "Installing W2003 on BM Infinity
4500R" <InstallingW2003onBMInfinity4500R@discussions.microsoft.com>
wrote:

>> "Installing W2003 on BM Infinity 4500R"
>> <InstallingW2003onBMInfinity4500R@discussions.microsoft.com> wrote:
[quoted text clipped - 29 lines]
>objects? I feel I will need to master this list if I am to develop InfoPath
>forms of any complexity at all.

I listed them all in the thread I referred to.  There are only methods
to create Connection and Recordset objects.

Regards,
Steve
--
Please post questions to the newsgroup; everyone benefits.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.