Code

Re: Stored Procedure Code

Tome — Thu, 14 Jun 2007 16:40:51 GMT

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.

Re: Stored Procedure Code

Patrick Halstead — Thu, 14 Jun 2007 07:06:10 GMT

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?

Stored Procedure Code

Tome — Tue, 12 Jun 2007 15:58:14 GMT

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");
}