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
wwHttp
doesn't use anything COM related so I'm not sure that the error is originating there...
+++ Rick ---
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.
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 ---