COM+ Problem

Posted on 2003-02-19
Medium Priority
Last Modified: 2007-12-19
I've got a few COM+ applications that all register on the web server - a particular class within one application's DLL cannot be instantiated. The others work fine - even other applications that are installed before and after this particular one work fine.

The same DLL has been installed on other servers and work fine - and all classes can be instantiated without problem. From a scrap of vbs which calls the object, I get a "error loading DLL: 'createobject'" and from the web app (ASP) I get a page error "create object failed" "an error occurred while creating object 'objectname'"
It is not working in VBS and it is not working in ASP. Two components of the DLL ARE working, but 5 out of 7 are not. These 5 components instantiate one of the two components that DO work.
component prodversion returns the DLL version - this works
component dbobject runs sql server stored procedures - this works
component clients uses dbobject to verify user database permissions (by using dbobject) - but doesn't work
it does this like so:

Const m_modname As String = "myapp.clients"
Private m_dbobject As dbobject

Private Sub Class_Initialize()
   Set m_dbobject = CreateObject("myapp.clients")
End Sub

I think it fails at the CreateObject.
The code is identical for other apps - the same classes, the same code - just the application name (myapp) is changed.
It also works on other servers.

So to round up...
The same code compiled as a DLL for COM+, works on servers A & C but not server B. Other applications with the same code work on A B & C. Other applications installed on B before and after the problem application work fine.

I have no idea how to solve this - if I had more points to allocate to an answer I would.

Question by:kenkthulhu

Expert Comment

ID: 7985728
What does the COM component do?

Expert Comment

ID: 7985798

Try to check whether the component is registered on server B or not also Check its progID, (it is there in the registry or not).


Expert Comment

ID: 7986908

If I were you I'd trawl the registry to search for the ProgId of the component which is giving you trouble. Remove all instances and re-register.

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Expert Comment

ID: 7986912

...should have said...

(1) Drop the component from COM+
(2) Trawl the registry & remove all instances
(3) Add to COM+

(adding to COM+ does all the regsvr32 stuff)


Author Comment

ID: 8014193
The Registry seems pretty scary - I wouldn't like to start hacking into some of that stuff without knowing what it is. Shouldn't removing the application clean up any instances?

Accepted Solution

bukko earned 1200 total points
ID: 8015723

In theory, yes, but unfortunately not always.
And you are right to be scared of the registry. Do not make any mods unless you are confident in what you are doing. Is there a techy within your organisation who can help you do this?


Author Comment

ID: 8149461

I really will never know if your suggestion will work - the web dba tried again a few days later and the app installed and registered correctly.

The points are yours anyway - perhaps you can answer my other question about web page time outs.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question