Problem: The Email ActiveX was up and running from SQL Server and ASP without a problem. Suddenly it no longer runs and fails on the CreateObject. SQL gives a negative return code. The error under ASP is:
Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /testing.asp, line 10
It was all working fine previously. I modified the DLL permissions to give everyone full control. This fixed the problem under ASP, but not under SQL. The line failing within SQL is:
EXEC @hr = sp_OACreate 'Chilkat.MailMan2', @mailman OUT
asked Oct 31 '12 at 08:41
The cause of the problem is due to something amiss on the computer where SQL is running (and where the ActiveX DLL should be present and registered). It's virtually impossible for Chilkat to help in these sorts of situations. The best Chilkat can do is to suggest possible causes from years of past customer support experience, or suggest ways of finding more information about the problem.
When faced with ActiveX permissions problems, make sure the DLL is not located in a non-local (i.e. mapped or shared) directory. Windows will not fully trust the files on these mapped directories (unless they are modified to be fully trusted), and this can cause permissions problems.
It's also good to Google the error message. Literally cut-and-paste "Server object error 'ASP 0178 : 80070005'" into Google and see what is found. In this case the search results contain many promising leads, the first of which is:
In the end, this problem was solved by discovering that some person on the server side got rid of permissions on the 32-bit ActiveX, and completely unregistered the 64-bit ActiveX.