Run-Time error 430

[broncofrk98]

I have been developing a Shipping Database using a VB6 front end and SQL 2000 on the back end. The application works fine on my computer, but when I load it onto another machine I get this error:
"Run-time error '430' : Class does not support Automation or does not
support expected interface."

Both my machine and the machine that I am loading it on are running 2000 professional. I have tried using the PDW as well as just sending it an .exe, but neither work.

Help advises to use regsrvr32.exe to unregister the dll and then regester the .exe(?). I have deployed a dependency file on it and then used that to unregister and re-register every dll it would let me, but still no dice.

The applications seems to crash when it is writing to the DB, but seem to read from it fine.

Any suggestions?

[TheBao]

Try to install the software again on the target machine, you'll notice that mdac_typ.exe might be the wrong version. I think PDW picks up this wrong.

To fix it, get the correct mdac_typ.exe and install it on the target machine, you may get it works.

Regards.

[yrwyddfa]

The interface on one of the classes, or DLL's which you application has changed.

To avoid:

Make sure you recompile the app with all of the references set to what they are likely to be on the client machine

Make sure all objects are created with CreateObject

Set Binary Compatibilty on

If it's an external DLL, then ensure the versioning is correct. You may need to use RegClean, or a similar utility after attempted installs.