| SammyBar 2005-07-27, 9:23 am |
| Hi all,
We have a sp that sends http requests. It uses Microsoft XMLHTTP component
that is part of XML pack that is standard with SQL Server 2000 SP3. For an
unknown reason the XMLHTTP component started to fail raising the error:
OLE Automation Error Information
HRESULT: 0x800c0005
I've seen this error in Visual Basic 6 when trying to create a component
that is not well installed. But here this error is raised when creating the
object but when sending the request:
Exec @nError = sp_OACreate 'Microsoft.XMLHTTP', @iReq OUT
If @nError != 0
Begin
Select @nError = Null
Raiserror('sp_OACrea
te Microsoft.XMLHTTP FAILED! [sp_send_http]', 16, -1)
Goto Fin
End
Exec @nError = sp_OAMethod @iReq, 'Open', NULL, 'POST', @sUrl, false,
@sUser, @sPassword
If @nError != 0
Begin
Raiserror('sp_OAMeth
od Open FAILED! [sp_send_http]', 16, -1)
Goto Fin
End
Exec @nError = sp_OAMethod @iReq, 'send'
If @nError != 0
Begin
Raiserror('sp_OAMeth
od Send FAILED! [sp_send_http]', 16, -1)
Goto Fin
End
then it goes well through sp_OACreate and sp_OAMethod "Open" calls.
I reregister msxml.dll, msxml2.dll, msxml2.dll, and restarted the server but
it was useless.
Looking around on the server logs the only suspected entry I've found was:
SqlDumpExceptionHand
ler: Process 397 generated fatal exception c0000005
EXCEPTION_ACCESS_VIO
LATION. SQL Server is terminating this process..
* -------------------------------------------------------------------------------
* Short Stack Dump
* 09C73F85 Module(UNKNOWN+00000
000)
* 0066A220 Module(sqlservr+0026
A220) (MSXMLThreadDetach+0
000003D)
* 00505DF1 Module(sqlservr+0010
5DF1) (clean_process+00000
0C6)
* 0050611D Module(sqlservr+0010
611D) (kill_proc+000000EE)
* 00506513 Module(sqlservr+0010
6513) (logout+000001AC)
* 005063D8 Module(sqlservr+0010
63D8) (release_srvproc+000
00045)
* 004270F9 Module(sqlservr+0002
70F9) (process_commands+00
0002A2)
* 41075002 Module(UMS+00005002)
(ProcessWorkRequests
+00000272)
* 41074698 Module(UMS+00004698)
(ThreadStartRoutine+
00000098)
* 7800C9EB Module(MSVCRT+0000C9
EB) (beginthread+000000C
E)
* 77E8B2D8 Module(KERNEL32+0000
B2D8) (lstrcmpiW+000000B7)
* -------------------------------------------------------------------------------
It looks like after that the XMLHTTP doesn't works.
Then my problem is to restore the XMLHTTP component to normal state. It runs
on a production server so the rules here are very strict. We cannot install
any new package there. So just reinstalling the xml package is the least
desirable solution. I'd prefer just reregister the proper dlls but it looks
like reregistering msxml?.dll is not enought.
What should I do?
Should I register any other dll associated to msxml?.dll
Any idea is welcomed
Thanks in advance
Sammy
|