Calling a web service from T-SQL (Stored Procedure) using MSXML [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

---

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 8 years ago.

Improve this question

enter image description here

EXEC @hResult = sp_OAMethod @objectID, 'send', null, @requestBody 
 IF @hResult <> 0 
 BEGIN
 EXEC sp_OAGetErrorInfo @objectID, @source OUT, @desc OUT
 SELECT hResult = convert(varbinary(4), @hResult), 
 source = @source, 
 description = @desc, 
 FailPoint = 'Send failed', 
 MedthodName = @methodName 
 goto destroy 

When I Call a web service Through Sp IN SQl Server In Above Mention I'm getting error as Shown In The Pics

• Tom V: Well it looks like you can't connect to the server right? are you sure it works when you call it from outside sql server (like using soapui)?
• Alfaiz Ahmed: @TomV Yes you are Right Suppose in Case If My Server service is not Started how can I send request from Sql with out such error
• Tom V: If your server isn't running I don't understand how you could send a request to it without error
• Alfaiz Ahmed: OK Is Their Any Alternative How Can I Save The Data Whose Sending is getting Fail

Answer 1

Not sure about that exact error, but I would advise against using the OLE Automation stored procedures (i.e. sp_OA*) as they have been deprecated since SQL Server 2005 was released and have various "issues".

I you need to interact with a Web Service, your best bet is to use SQLCLR. I have more info regarding this option in the following answer, also here on DBA.SE:

Bringing web service data into SQL server