|
Home > Archive > MS SQL XML > July 2005 > RE: Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLSer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLSer
|
|
| Mike Epprecht (SQL MVP) 2005-07-27, 9:23 am |
| 0x800c0005 = Error 5 = Access Denied.
What has changed on the server?
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SammyBar" wrote:
> 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
>
>
>
>
| |
| SammyBar 2005-07-27, 11:37 am |
| > 0x800c0005 = Error 5 = Access Denied.
!!!
Where did you find error codes?
> What has changed on the server?
Nothing. It is in the production server and it is forbidden to change
anything..., even security patches...
| |
|
|
| Mike Epprecht \(SQL MVP\) 2005-07-27, 1:28 pm |
| Hi
It is the standard COM error. After seeing the same ones for 10 years, you
generally get to know them.
You can strip the last 4 characters, and use them as Tibor Karaszi noted in
his post.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SammyBar" <sammybar@gmail.com> wrote in message
news:%23ZP6ykskFHA.3144@TK2MSFTNGP12.phx.gbl...
> !!!
> Where did you find error codes?
>
> Nothing. It is in the production server and it is forbidden to change
> anything..., even security patches...
>
>
| |
| SammyBar 2005-07-27, 8:24 pm |
| > What has changed on the server?
Ok, I found the error. Somebody activated a second NIC on the server and
that mangled the network routes. The server that was being requested was not
available by pinging. That is way the error was raising on the "send"
method.
Thanks you all for the hints
Best regards
Sammy
|
|
|
|
|