>I'm just trying to query VFP data, no changes or updates to the data will be made.
>
>I have been able to do simple SPs. This error is due to OleDB access permissions.
>

I guess there are not many people who tried accesing VFP data and then trying to make it an SP. Is there a specific reason you want to have this an SP and not just a code in .NET ?

>>Are you trying to manipulate VFP data from SQL Server? Have you succeed making simple CLR SP (no VFP involved)?
>>
>>>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?