Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CLR Integration
Message
De
04/06/2008 10:39:52
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
03/06/2008 09:16:52
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
01321269
Message ID:
01321605
Vues:
13
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform