InnerException: Request for the permission of type 'System.Securit

( does anyone have an ASPRunner .Net app runing on a Medium Trust, shared hosting environment ? )

ASPRunner.NET generates applications that should work in Medium Trust mode. You should contact your shared hosted provider.

"should" work with medium trust?

( does this mean you don't have documented test results from execution within a medium trust env? )
I was given the trust info from my web host. When I implimented this trust on my local machine, I recieved the same results.

I might be able to make a case to my hosting provider to make a change on their config, if my case is good enough.

Forgive my persistance, but I need to VERIFY that I can get solutions created with ASPRunner.Net will work before making the decision to purchase it. In case you would like to glance at the config and make any suggestions, here is the config:

-----------------------------------------------------------------------------------------------

<configuration>

<mscorlib>

<security>

<policy>

<PolicyLevel version="1">

<SecurityClasses>

<SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="ConfigurationPermission" Description="System.Configuration.ConfigurationPermission, System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

<SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/>

<SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

<SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="SmtpPermission" Description="System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="OleDbPermission" Description="System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="OdbcPermission" Description="System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<SecurityClass Name="OraclePermission" Description="System.Data.OracleClient.OraclePermission, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

</SecurityClasses>

<NamedPermissionSets>

<PermissionSet

class="NamedPermissionSet"

version="1"

Unrestricted="true"

Name="FullTrust"

Description="Allows full access to all resources"

/>

<PermissionSet

class="NamedPermissionSet"

version="1"

Name="Nothing"

Description="Denies all resources, including the right to execute"

/>

<PermissionSet

class="NamedPermissionSet"

version="1"

Name="ASP.Net">

<IPermission

class="AspNetHostingPermission"

version="1"

Level="High"

/>

<IPermission

class="ConfigurationPermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="DnsPermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="EnvironmentPermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="FileIOPermission"

version="1"

Read="$AppDir$"

Write="$AppDir$"

Append="$AppDir$"

PathDiscovery="$AppDir$"

/>

<IPermission

class="IsolatedStorageFilePermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="PrintingPermission"

version="1"

Level="DefaultPrinting"

/>

<IPermission

class="ReflectionPermission"

version="1"

Flags="ReflectionEmit"

/>

<IPermission

class="RegistryPermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="SecurityPermission"

version="1"

Flags="Assertion, Execution, ControlThread, ControlPrincipal, RemotingConfiguration"

/>

<IPermission

class="SmtpPermission"

version="1"

Access="Connect"

/>

<IPermission

class="SocketPermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="SqlClientPermission"

version="1"

Unrestricted="true"

/>

<IPermission

class="WebPermission"

version="1"

Unrestricted="true"

/>

<IPermission class="OleDbPermission"

version="1"

Unrestricted="true"

/>
<IPermission class="OdbcPermission"

version="1"

Unrestricted="true"

/>
<IPermission class="OraclePermission"

version="1"

Unrestricted="true"

/>

</PermissionSet>

</NamedPermissionSets>

<CodeGroup

class="FirstMatchCodeGroup"

version="1"

PermissionSetName="Nothing">

<IMembershipCondition

class="AllMembershipCondition"

version="1"

/>

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="ASP.Net">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="$AppDirUrl$/"

/>

</CodeGroup>

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="ASP.Net">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="$CodeGen$/"

/>

</CodeGroup>

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Nothing">

<IMembershipCondition

class="ZoneMembershipCondition"

version="1"

Zone="MyComputer" />

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Microsoft_Strong_Name"

Description="This code group grants code signed with the Microsoft strong name full trust. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1"

PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4A

ED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD2361321

02900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1A

B99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD2

93"

/>

</CodeGroup>

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Ecma_Strong_Name"

Description="This code group grants code signed with the ECMA strong name full trust. ">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1"

PublicKeyBlob="00000000000000000400000000000000"

/>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</PolicyLevel>

</policy>

</security>

</mscorlib>

</configuration>

note:

just for grins and chuckles, I restored my local pc's original, untouched web_mediumtrust.config and tried again....

I got the same results.

My pc is a rather fresh (vanilla) install XP Pro, Visual Web Dev 2008.

This means that all else left alone, I was able to break it, getting the "InnerException: Request for the permission....." error with the only change having been the one in my machine's web.config

from: <trust level="Full" originUrl="" />

to: <trust level="Medium" originUrl="" />
Unless I am mising something, the evidence is beginning to stack up against ASPRunner.Net apps running with Medium trust.

8-(

Could you please send me your project (including project file, output directory and database backup) on support@xlinesoft.com? I'll run your project on my box in medium trust mode.

I would be happy to send you my trust config files, but although I appreciate your interest in figuring this one out, even though I am only a 'trial' user, I would reply (with all due respect) that sending you my project should not be necessary.

My PC, as I mentioned, is very much a vanilla install, with the exception of additionally having /net 3.5 framework and VWD 2008 installed, instead of only having VWD 2005 & .net 2.0.

The version of ASPRunner .Net I am trying out is v4.0 build 173.

Aside from providing the database location and credentials, I am accepting ALL defaults within the wizard. (Next, Next, Next, etc...)

If you say that not only 'should' it work, but that you have created a project on your PC, without modification to a standard WinXP build on your pc, and it does with with medium trust, then I will presume that if I decide to go with your product, your support dept. will work with me to make it work.

As I mentioned before, I know it is not an issue withe the data source, because the credentials I have used in all of my testing has dbo.

When testing via simple gridview within Visual WebDev, I am able to edit even the primary key and delete records. The pages created with VWD requiring only medium trust on my PC.

I will say that one of the other solutions I've been considering (IronSpeed Designer) has documented that it will not execute properly in a medium trust environment.
The question to your company, from me, still stands....

Without seeing my project, within which I accept ALL defaults, have you created a C# project with v4.0 build 173 that can modify records in a remote MS SQL database with medium trust locally?

It would be enough for me to hear that you have actually done it yourself. (not just theorizing that it should work).

Unfortunately, you were right, when we update data in database in Medium trust mode, we receive bug:

InnerException: Request for the permission of type...
Perhaps, the following articles will help you:

http://learn.iis.net/page.aspx/50/configuring-aspnet/

http://msdn.microsoft.com/en-us/library/ms998341.aspx

Thank you very much for confirming my findings.

Every web host I have checked with so far utilizes medium trust, and for good reason.

If/When your company develops a solution for use in medium trust shared hosting .Net environments, please either update this thread so that I will be notified.

Thanks again.