West Wind Internet and Client Tools
wwHttp error for one installation only
Gravatar is a globally recognized avatar based on your email address. wwHttp error for one installation only
  Allen Belkin
  All
  Jun 5, 2024 @ 07:12am

Hi Rick,

We have an application that uses wwHttp with an XML request to run stored procedures on a remote SQL Server. All clients are using this application without problems, except one which starts receiving an error a few days after the application is installed. The reported error is “OLE error code 0x80040154: Class not registered”. The method name is “Http SendError” and system message is “SQL Call Error – “ plus sometimes the name of the stored procedure. I’m not aware of any class that needs to be registered. I think the IIS log shows 404 errors

If they re-install the application, it works – for a day or two, then the errors return. Any idea what’s going on?

Thanks, Allen

Gravatar is a globally recognized avatar based on your email address. re: wwHttp error for one installation only
  Rick Strahl
  Allen Belkin
  Jun 5, 2024 @ 11:42am

wwHttp doesn't use anything COM related so I'm not sure that the error is originating there...

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: wwHttp error for one installation only
  Allen Belkin
  Allen Belkin
  Jun 5, 2024 @ 08:08pm

I didn’t think so, could be a bogus error message. I suspect some system policy, firewall or IIS setting since it works for everyone else. We’ll have to do more tracing and logging.

Gravatar is a globally recognized avatar based on your email address. re: wwHttp error for one installation only
  Rick Strahl
  Allen Belkin
  Jun 6, 2024 @ 07:33am

It could be related to the XML COM component. If you're using SQL Server with SQL it relies on the Windows XML components and some of those have been deprecated and are flagged as security errors so they might not be installed.

I say because you mention SQL error and COM error - could be either SQL XML features or it could be the calling code using an XML parser to create/parse/retrieve the XML.

Basically make sure the MSXML (v4 I think) components are installed and working and not explicitly disabled.

+++ Rick ---

© 1996-2024