Automation error

[MarQ]

Hi..I just want to ask why my program says "automation error"..seems not reading the ado connection..what bothers me is that the program worked for like...6 months and then starts this kind of error. what bothers me more is that the program runs fine with other PC, same installer and everything I had with the PC that gives and error..may i know what is the best thing i can do about this, and what is causing the problem? I just want to know why this happened, so that in the future I know what I need to do..thank you in advance..help is greatly appreciated..Thank you again

 

[HarleyQuinn]

Has anything changed on the PC that the app now errors on???

Harleyquinn

---------------------------------
For tsunami relief donations

 

[MickTheBelgian]

Some OCX or DLL got overwritten with a different and incompatible version. Try uninstalling it and then reinstalling it again. If you have the sourcecode or a dependency checker, you can copy the DLL's into the same folder as the EXE, so they don't get overwritten again.

 

[MarQ]

I tried reinstalling the program. I also tried reinstalling VB and updates..still wont work..anymore suggestions?

 

[RubenV]

Are you sure that the system dsn you're connecting with is still there?

 

[MarQ]

What is meant by system dsn? all i knopw, nothing has been touched on that PC..the database is still there..

 

[Hokkie]

This may be of help to future readers:

I had the same problem for the last month. What I found was that my scrrun.dll was not properly registered. I got the problem with the FileSystemObject. There were two versions on my system, 5.6.0.8825 and 5.6.0.8820. It also ruined my VB.NET with a ClassFactory error.

I unregistered the 5.6.0.8825 version and reregistered it, and the problem has gone away.

Hope this helps!

__________________
code is enduring

 

[MarQ]

Thnaks for the answer...i was able to solve the problem almost a month ago..what i did, i reinstalled the windows service pack 2 for winxp since the OS was winxp and after rebooting it was already working.Thnaks again for the info..hope this helps you also