I've got a similar problem that I can summarise quite easily.

I do both

EXEC @hr = sp_OACreate 'Microsoft.XMLHTTP', @xmlHTTP OUT

and

EXEC @hr = sp_OACreate 'Microsoft.XMLDOM', @xmlDOM OUT

and set some properties, call the...