Error no. -2147023782 Automation error A dynamic link library (DLL) initialization routine failed.

This line of code doesn't work on one  machine out of hundreds:

Set CZip = CreateObject("V8ReportHistory.ZIP")

This is an error :

8/7/2006  ---  11:05:25 PM  ---  RunReports - Error no. -2147023782
Error description: Automation error
A dynamic link library (DLL) initialization routine failed.

I check it again , everything is registered and seems exactly as on the machines where it is working.
Any ideas, thanks.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RetalixUSAAuthor Commented:
If any additional info is needed , please indicate it and i will provide it.
lojk.Net and Infrastructure ConsultantCommented:
best guess is that the V8ReportHistory.dll is not registered properly... (or one of its dependancies is missing)

try a
regsvr32 dllfilename.dll /u
regsvr32 Fullpathtodll\dllfilename.dll

if that still doesnt work i would start by looking at my installed ISAM modules and ODBC drivers...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RetalixUSAAuthor Commented:
Everything is registered correctly.
The fact is that other applications on the same machine are using successfully this class.
The error on create object happens sometime , not every day. Reboot of the machine makes it work for additional period of time and then again failure on :
                        Set CZip = CreateObject("V8ReportHistory.ZIP") ' New ZIP

Any ideas ?
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

lojk.Net and Infrastructure ConsultantCommented:
you would need to check in the initialisation code of the instatiated class. its probably failing because it cant create an instance correctly

perhaps a log file that its using is in use at the time of instantiation or some other condition that is preventing the creation of the class. perhaps it use a class that can raise a modal form and/or that is not multithreaded correctly or releaseing control to the dll when required.

i would really need far more information (preferably source) on the v8reporthistroy file, what files does it depend on, what files does it write? what permission does it need on the machine (registry etc). What does it actually do?
Did anyone find a solution to this?
No thats wots great about experts exchange
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.