"Class does not support automation"

[hmscott]

I am getting an error "Class does not support Automation or does not support expected interface".

Here are the circumstances:
Operating system:
Client: Win2K or WinXP Pro (error occurs on either)
Server: Win2K (SP4)
Application:
IIS 5 (web server)
Custom COM+ Object (built with VB 6.0 SP5)
SQL Server 2000 (SP3)

Last week, I installed VB .NET onto my notebook. Today, I was looking through the code for my custom COM+ object and decided to tweak it slightly: mostly adding Option Explicit where it had been left out. After recompiling it and installing it onto the web server, I began getting the error shown above.

When I restore a previous version of the .DLL, I do not get the error.

Google searches tell me that the problem is with my MDAC. The VB 6 project file references MDAC 2.6. I reinstalled MDAC 2.6 with no success. I reinstalled MDAC 2.7 (which was installed when SQL 2000 SP3 was installed) and still no luck. I have rebooted the server.

Any help here would be greatly appreciated.

Regards,

hmscott

 

[paulbent]

When you recompiled the dll, did you maintain binary compatibility with the previous version? If not, the interface GUIDs may have changed and you need to reinstall/unregister the old version before replacing it and registering the new version.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[hmscott]

Paul,

Many thanks. I had completely overlooked that option. I was beginning to lose a significant chunk of my hair over this one as it was beginning to extend to other DLLs that I have created over time.

Thanks again,

hmscott