>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?
If it's not broken, fix it until it is.
My Blog