I have an ActiveX DLL (developed in VB) running as an MTS object that uses the Excel Object (Excel9.olb). When I run this on a local MTS server, it runs fine. When I put it out on to a remote server I get the generic Error 20 Permission Denied. (This occurs when I use the CreateObject("Excel.Application") method.)
I figured that maybe MTS did not like the Excel object so I created a regular DLL (not MTS object) and registered it on the server. Then I created an MTS object that called this local DLL. Once again this worked on my local machine, but not on the server. I get exactly the same results.
I am set up as an administrator on the server. I also set the permissions to full control for Everyone and added my own ID with full control as well. My ID was used to log on to the server as well.
What could I be doing wrong? Please help!