We help IT Professionals succeed at work.

Help on Automation error in VB6

TJVJ
TJVJ asked
on
1,469 Views
Last Modified: 2013-12-25
I have created a setup for my VB 6 project. It uses Access 2000 and DAO 3.6. It installed fine on users machine. Now when they try to run it it gives the error "2147417848(80010108)
Automation Error. The object invoked has disconnected rom its clients." I am not using the MSCAL.ocx.
I am using Becube Ocx controls and Sizer one and ADO data control.

Comment
Watch Question

CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi Dabas,
It might sound stupid, but I am frustated. I tried to install MDAC on the development machine and on the end user machine also. I still get the same error. Should I recompile my project?? I am using XP and my users use XP, 98 and Me machines.
Right now , I am testing on XP user machine.
CERTIFIED EXPERT

Commented:
TJVJ,
First step is to identify exactly which source line is causing your error.
Error messages can be confusing and incorrect.
Try to add error handling to your program.
If you can, add Line numbers to your source code, and in your error handling, bring up a messagebox with the Error number, Description and with the Erl, the line number.
It will help to identify exactly what is causing your problem

Dabas

Author

Commented:
Thanks for your prompt reponse. I'll try that.
Normally this error is caused by mscal.ocx on XP machine.

http://support.microsoft.com/default.aspx?scid=kb;en-us;194912

Commented:
Make sure that all dependencies of BeCube and SizerOne are also installed on client machine.

Author

Commented:
The strange part is that it gives me this error only on clicking two buttons in my form. The two buttons open up another forms in which data is being populated in the listbox(Becubed) from the database. Other places the same thing works fine.
Yes, All the dependencies are installed on that machine.

Commented:
Hmmm...what all controls do you have on those two forms? Any dialog box or media player or calendar?

Author

Commented:
Hi Sethi,
The strange part is that it works fine sometimes and then it shows error and then works fine. I am in a loop. The form has becubed listbox, becubed textboxes, picture boxes and checkboxes. I have downloaded visual basic SP5 just in case and MDAC 2.7 also but still???

Commented:
Check for some bugs and fixes with becubed controls. you may find something helpful there.
I too am suffering the same problem. I compiled my project on my 98 PC. I have Office 2000 at my place. My client had a XP and it worked there; but on another PC which has Win98 and Office2000, I get the Automation Error.

I put a break point and found out that the error occurs an the line

Set X = CreateObject("Excel.Application")

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.