Is is possible to leverage a secondary datasource's connection?

[Gregs List Acct]

In my scenario I have about 5 secondary datasources that I clone into on
offline xml node. When the form is off-line users can add/remove/update
items in those cloned nodes.

When the user goes back on line I'm using custom code to call SQL Stored
procs to make those updates back to SQL since Infopath's submit only handles
the Main datasource. As a result, I have to create an ADODB.Connection and
ADODB.Command, and the users get a security warning about ActiveX objects. I
can trap the error if they tell IE not to allow it, but I was wondering if
there was a way to leverage the existing secondary datasources'
dataconnections so they only deal once with telling IE to allow the code to
run.

Does that make sense?

 

[Franck Dauché]

Hi,

If you want to bypass the security warning you can search in this forum for
the following thread: "ADO Security Warning - using identity to access a data
source" (dated 10/10/2005).

Regards,

Franck Dauché

 

[Greg S]

Will signing a form also get past the warnings of creating ActiveX objects?
I'm creating ADODB connections and commands to call SQL sprocs in code and
that produces a standard IE warning vs. an InfoPath warning.

Just want to make sure it handles both before I head down that path.

Thanks!
Greg

 

[Franck Dauché]

From my experience, this, combined with the security level of the form always
does the trick..

Good luck.

Franck