March 6, 2013 at 7:44 am
Hi All,
Need some clues...
Scenario: I have created a .Net assembly based on an old VB6 ActiveX library(.dll).
Why? Because I'm working with an old system and we don't have source code.
I've modified the rssrvpolicy.config file the same way I did my RSPreviewPolicy.config.
On the server that is hosting SSRS, I've registered the ActiveX DLL.
In SSDT my test report runs fine and I get a value from the new .Net assembly.
When I run it from the server I get the "#Error" in the text boxes.
Setup:
SSRS 2012
ActiveX DLL is registered on the server
Added code group for both the .Net assembly and the RCW wrapper with FullTrust (rssrvpolicy.config, RSPreviewPolicy.config)
RCW wrapper created with tlbimp.exe
SecurityPermission(PermissionState.Unrestricted) asserted
Assembly:AllowPartialTrustCallers
Question:
Why would it work in my SSDT but not from the SSRS rpt manager?
It's having problems getting to the old registered ActiveX library.. is there another permission I need to raise?
Help is greatly appreciated...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
March 6, 2013 at 2:47 pm
Nevermind... can't do it the ActiveX COM object is 32bit and SSRS is 64bit...
my IDE is 32bit... oh well...
If anyone know's magic to get it to work let me know...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply