Link to home
Start Free TrialLog in
Avatar of TJVJ
TJVJ

asked on

Help on Automation error in VB6

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.

ASKER CERTIFIED SOLUTION
Avatar of Dabas
Dabas
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TJVJ
TJVJ

ASKER

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.
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
Avatar of TJVJ

ASKER

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

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

ASKER

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.
Hmmm...what all controls do you have on those two forms? Any dialog box or media player or calendar?
Avatar of TJVJ

ASKER

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???
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")