InfoPath Dev

Any ideas why the code below only works when the form is NOT fully trusted?

var conn = new ActiveXObject("ADODB.Connection");
conn.ConnectionString = XDocument.QueryAdapter.Connection;
conn.ConnectionTimeout = XDocument.QueryAdapter.Timeout;
try
{
    conn.Open();
    conn.Execute('execute "dbo"."csp_GetSR4" ' + conid + ', ' + busid + ' ,' + id);
    conn.Close();
}
catch(ex)
{
    XDocument.UI.Alert("Error 02 - Encountered problem running SQL Stored Pocedure");
}
 

Hi Tome,

Where are you running the form from? Is it published to a local machine or a website? Is the SQL database in the intranet domain?

The original form is not fully trusted and runs from the SharePoint site which exists within the intranet. The SharePoint site and the SQL DB are running on the same box.

What I am attempting to do is add some extended functionality to the form, and to do that I'm making the form fully trusted where the user would install it via msi to their pc. The code does not seem to work at that point.