Solved

ActiveX can't create object - which object?

Posted on 2008-06-19
19
404 Views
Last Modified: 2013-11-18
Runtime error 429 - Activex can't create object

Why does this error not display which object, either by name or guid?  How can I make it display some useful error information?

0
Comment
Question by:pjsulin
  • 7
  • 7
  • 3
  • +2
19 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 21825624
Hello pjsulin,

If you run it from the VBIDE, does it run successfully?  If not, what line does the debugger jump to?

Does the exe fail on all computers?  For all users?

Regards,

Patrick
0
 

Author Comment

by:pjsulin
ID: 21825696
It runs fine from the ide, the problem is installing on one computer.  All the references should be good, I'm using Visual Build Pro to ensure that all dll's are built together and the install is done through a batch file.  My question is more in regards to troubleshooting this problem in general than this problem in particular.  I know that a dll is somehow out of synch, that is why I use Visual Build Pro and a batch file to unregister, delete, copy and re-register all the dll's.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 21825735
Try inserting a ton of MsgBox's in the code to indicate where you are in the program, or better yet
trap errors with an error handler to get a better fix on where it's breaking down.
0
 

Author Comment

by:pjsulin
ID: 21825775
loading dll's is done before code is executed, so that does not help.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 21825794
But it's a runtime error
0
 

Author Comment

by:pjsulin
ID: 21825821
yes it is a runtime error, but how do you write code that runs before dll loading?
0
 
LVL 4

Expert Comment

by:anmalaver
ID: 21825872
Hi

Maybe it can be useful:
Look for Dependency walker (Depends.exe) on your VStudio folder and execute it on the PC you're using the control. It will tell you if any dll or reference is missing.

Try it, it is very useful.
0
 

Author Comment

by:pjsulin
ID: 21825911
I have tried Dependency Walker and it does not tell me which dll failed to load.
0
 
LVL 4

Expert Comment

by:anmalaver
ID: 21825929
Did you use it on the other PC?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Expert Comment

by:anmalaver
ID: 21825934
What version of VB are you using?
0
 

Author Comment

by:pjsulin
ID: 21825944
I have it installed on every machine. What "other" machine are you referring to?
0
 
LVL 4

Expert Comment

by:anmalaver
ID: 21825952
The machine that is not working on...
What version of VB IDE are you using?
0
 

Author Comment

by:pjsulin
ID: 21825970
VB6 - Version 8176
0
 
LVL 4

Expert Comment

by:anmalaver
ID: 21826060
1)Look for the .Net framework on the other machines, it's possible that it is in conflict with your dlls, or that install overwrites your DLLs...

2)You should check the version of the DLLs you see in Dependency walker in the other machines.

3)Try creating an installer from VB6 to overwrite and register the DLLs that you need
0
 
LVL 4

Expert Comment

by:anmalaver
ID: 21826071
4) Did you register your control? How did you do it?
0
 

Author Comment

by:pjsulin
ID: 21826187
Let me start this over, after addressing the last comments and correcting one of my own.

anmalaver, please read the previous comments before posting.  I use a batch file which, unregisters, deletes, copies the new dlls (every one of them), and then registers them.  So I know that they are all the same and registered.  This I stated in my second posting.

I stated earlier that error handling code would not work because the error is thrown when the dll is loaded.  This is not true, the error happens when the object is created.  

What I'm asking for is a way to make the vb error more informative.  All of my newer code has extensive error handling, but the older code I adopted does not.  I do not want to go back and add error handling code to the 15 vb libraries that my systems use.

I will restate the original question:

Why does this error not display which object, either by name or guid?  How can I make it display some useful error information?



0
 
LVL 4

Expert Comment

by:anmalaver
ID: 21826224
I think you should see the entries in the registry for your DLLs to ensure that there is only one DLL registered.

See this, if you haven't...
http://www.vbaccelerator.com/insprob.htm

Bye
0
 
LVL 2

Expert Comment

by:team2005
ID: 21826241
Hi

This code vil give you more information on the error

First you must have this line of code, at the top of the sub or function.

On error goto errormess

---

--

errormess :
      Msgbox "Error : " & Error(Err.description)

This wil give you a complete description on a error


0
 
LVL 7

Accepted Solution

by:
TRobinJames earned 500 total points
ID: 21826517
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now