Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CLR Integration
Message
From
04/06/2008 10:39:52
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/06/2008 09:16:52
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01321269
Message ID:
01321605
Views:
12
>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?

Probably you marked it as safe.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform