Unloading ActiveX dlls from a vb app whilst it is running.

Posted on 2004-09-27
Last Modified: 2012-06-21
Hi all,

(note this is related to another question:
I'm writing a application that will eventually have little 'agents' that are running on about 70 computers on a WAN.

Basically, I have a central application that via tcp/ip sends xml commands to these agents, which in turn do 'stuff' based on the xml commands and return a result.

Because the only way i have access to these agents is via a ssh tunnel and vnc, i decided that i really dont want to log onto by opening the tunnel and a vnc session 70 times whenever i need to upgrade the exe. Instead, I have a system where dll's are dynamically loaded based on a config file. the idea being i can just send a xml command (and some binary data) to add new dlls and update the config file so the agent knows how to respond to new xml commands (or to fix any problems in existing dlls).

PROBLEM: I need to be able to unload the activex dll (if it is current instantiated) from the current app so that i can replace the dll file.

I am using CreateObject to load the activex dll

Thanks in advance for your help.
Question by:gimmeadrink
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 125 total points
ID: 12160460
You have to set all the object references from this ActiveX dll to nothing, and ensure that you have NO circular references inside the objects keeping them alive. To enforce this, a "DISPOSE" method of the main object(s) should be implemented to tell the object to fully cleanup and close.

LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 12160475
Another gotcha in that area:
if you have a class defined as global in the activeX dll, and added the activexdll in the references of the calling application, you have to remove this, because this is something you won't be able to unload from the vb app...


Author Comment

ID: 12164639
Ok thanks for that, i will try this today.

I have not added it as a reference because, at the time i build the exe, i have no way of knowing which dlls my agent will eventually need.... so i dont think the second part will be a problem

I did set it to nothing, but I do however have references from within the main class to other classes within the same dll. I never thought about thanks a lot.

If i have a terminate sub in the class, will that be called when i set it to nothing? If not, i could just force each class to have another method that does this. Ill give this a go today sometime, thanks for your ideas so far.
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.


Author Comment

ID: 12165796
Ok, i have given it a shot, but i cant get it to work correctly.

I am pretty confident that i have set all objects in the dll to nothing.

I have also set the main object to nothing (gives an error to indicate this if i try and access it again later), but the dll is still not unloaded.

When i try to override it, its gives me a permission error.

any ideas?
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 12167045
>>If i have a terminate sub in the class, will that be called when i set it to nothing
The Terminate Event of the class will ONLY be called when ALL of the references to the object have been released. Thus if you create 2 objects that reference each other, you cannot get them released easily unless you have the "dispose" function  which will remove the circular reference(s) ...

You might try to send me the code, so I could look at it... (see my profile for the email, don't forget to remove any confidential settings from the code).


Author Comment

ID: 12206034
Thanks for your help angel

Sorry about the long wait in response, being doing a whole bunch of things at once and couldnt get back to this part of the app straight away.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

734 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