HellBound Hackers
Join us at IRC!
It is never to LATE to become what you never WERE.
Friday, May 25, 2012
Navigation
Home
HellBoundHackers Main:
HellBoundHackers Find:
HellBoundHackers Information:
HellBoundHackers Additional:
Shop
Learn
Communicate
Submit
Challenges
HellBoundHackers Exploit:
HellBoundHackers Programming:
HellBoundHackers Think:
HellBoundHackers Track:
HellBoundHackers Patch:
HellBoundHackers Other:
HellBoundHackers Need Help?
Interact
Other
HellBoundHackers Executive:
HellBoundHackers Leisure:
Members Online
Total Online: 43
Web Spiders: 14
Guests Online: 42
Members Online: 1
johny34

Registered Members: 70216
Newest Member: ____x____
Latest Articles
View Thread

HellBound Hackers | Computer General | Webmasters Lounge
Author

RE: SQL Problem...Show Your Mastery
zumo
Member

Posts: 20
Location:
Joined: 12.11.06
Rank: Moderate
Posted on 11-06-08 16:01
allright scratch all the service broker crap..

i've got c# code running on a thread that is processing rows when its sent them. everything is working beautifully. but i need to call it from SQL. the only way i know how to do this is compile the csharp code into a DLL then create an assembly out of the dynamic link library then create a stored proc outta that. i did all this and now have a stored procedure that is referencing a certain method in my csharp code that in turns runs everything.

but when i try to execute the code i get this terribly frustrating error.

A .NET Framework error occurred during execution of user defined routine or aggregate 'trig':
System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.

The protected resources (only available with full trust) were: All
The demanded resources were: UI

System.Security.HostProtectionException:
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Object assemblyOrString, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Object assemblyOrString, SecurityAction action, Boolean throwException)
at System.Security.CodeAccessSecurityEngine.CheckSetHelper(CompressedStack cs, PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Assembly asm, SecurityAction action)
at FileTrigger..ctor(SqlConnection conn, String cmd)
at FileTrigger.run(String cmd)

anybody else ever get this lil guy? thanks in advance.
Guest
Username

Password

Remember Me


Bookmark This Page
Affiliates
Adverts

 

 

Links

Anime Wallpaper Site
By using, viewing or obtaining any information contained on this site, you agree to the disclaimer.

© HellBound Hackers 2008- 2009. Since 3rd December 2004.

20613784 Unique Visits

Powered by HBH-Fusion