Kbase P156332: Error when creating assembly refering to .NET Open Client proxy within MS SQL Server with PERMISSION
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/11/2009 |
|
Status: Unverified
SYMPTOM(s):
Error when creating assembly refering to .NET Open Client proxy within MS SQL Server with PERMISSION_SET = SAFE
CREATE ASSEMBLY failed because method 'decode' on type 'Progress.UBroker.Util.Base64' in safe assembly 'Progress.o4glrt' is storing to a static field. Storing to a static field is not allowed in safe assemblies.
FACT(s) (Environment):
Windows
OpenEdge 10.1x
OpenEdge 10.2A
MS SQL Server 2005
MS SQL Server 2008
CAUSE:
Safe assembly cannot be created within MS SQL Server when a method is storing to a static field, which is the case for the method 'decode' in the Progress.o4glrt.dll assembly indeed.
FIX:
Create the assembly within MS SQL Server 2005/2008 with PERMISSION_SET = TRUE instead.
For example:
CREATE ASSEMBLY myAssembly FROM C:\temp\myAssembly.dll WITH PERMISSION_SET = UNSAFE