login about faq

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

The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

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

Any suggestions?

asked Oct 31 '12 at 08:41

chilkat's gravatar image

chilkat ♦♦
11.8k316358421


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:

http://support.microsoft.com/kb/315454

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.

link

answered Oct 31 '12 at 08:55

chilkat's gravatar image

chilkat ♦♦
11.8k316358421

edited Oct 31 '12 at 08:58

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×62
×11
×4
×1

Asked: Oct 31 '12 at 08:41

Seen: 3,035 times

Last updated: Oct 31 '12 at 08:58

powered by OSQA