Error: "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

[hmscott]

Someone in another forum pointed out that I had to check the option to "maintain binary compatibility". That seems to have done the trick.

Regards,

hmscott

[biswajitdas]

this is the conflict of new and older version.
check the dll configuratio about that