Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CLR Integration
Message
 
 
To
03/06/2008 10:37:56
General information
Forum:
ASP.NET
Category:
Databases
Title:
Miscellaneous
Thread ID:
01321274
Message ID:
01321377
Views:
16
You may also try to ask your question here
http://forums.microsoft.com/msdn/default.aspx?siteid=1&ForumGroupID=19

>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.
>
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform