>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?

Hi,

Maybe wrong SQL Server Host Policy Level Permission Set settings:http://msdn.microsoft.com/en-us/library/ms345101.aspx
?
Viv