Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CLR Integration
Message
From
03/06/2008 09:21:27
 
 
To
All
General information
Forum:
ASP.NET
Category:
Databases
Title:
CLR Integration
Miscellaneous
Thread ID:
01321274
Message ID:
01321274
Views:
58
I have created a Stored Procedure using the .NET SQL CLR Integration. I am trying to make an OleDB connection to a VFP database. I am getting the following error message when executing the Stored Procedure:
Msg 6522, Level 16, State 1, Procedure clr_pic_GetBacklogByOperation, Line 0
A .NET Framework error occurred during execution of user-defined routine or aggregate "clr_pic_GetBacklogByOperation": 
System.Security.SecurityException: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
System.Security.SecurityException: 
   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   at System.Security.CodeAccessPermission.Demand()
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.ExecuteReader()
   at StoredProcedures.pic_GetBacklogByOperation(Int32 op_Num)
I've spent several hours searching the internet for possible solutions with no luck. Does anybody have any idea how to fix this problem?
Thanks,
Dan Jurden
djurden@outlook.com
Next
Reply
Map
View

Click here to load this message in the networking platform