Error 10855, Severity: 20, State: 1

[chester27]

Need some help on this if possible. Have an application that uses a DB on SQL 2005. Error reported by App is that it failed to load msxmlsql.dll. Have trawled net and found all hotfixes ie

http://support.microsoft.com/kb/941105

but nothing worked.

I used SQL profiler and it get "Error 18055, severity 20 state 1 Exception %d, %d occurred when the server tried to reset connection %d Because the Server cannot recover from the failure to reset the connection"

Thanks in advance

 

[chester27]

The application code refers to an interface Microsoft.XMLHTTP

There are different versions of this interface in the different msmxl.dlls that are released by Microsoft

the reference in the registry for this interface was: %SystemRoot%\Msxml.dll with a Progid of Microsoft.XMLHTTP.1

I had to change these references to:

%SystemRoot%\system32\msxml3.dll with a Progid of Microsoft.XMLHTTP.1.0

The full registry key references amended are:

[HKEY_CLASSES_ROOT\CLSID\{ED8C108E-4349-11D2-91A4-00C04F7969E8}\InProcServer32]
Default value set to %SystemRoot%\system32\msxml3.dll

[HKEY_CLASSES_ROOT\CLSID\{ED8C108E-4349-11D2-91A4-00C04F7969E8}\ProgID]
Default value set to Microsoft.XMLHTTP.1.0

 

[gmmastros]

Are you using MSDE2000?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[chester27]

It's SQL 2005 and this was the fix, nothing to do with SQL as such.