Consuming a web service using a stored procedure

[Mohammad Al Hoss]

Hi all I am trying to consume a webservice using TSQL but I am getting a null result The method URL is http://localhost/SSISWebservice/service1.asmx The invoked url is http://localhost/SSISWebservice/service1.asmx/HelloWorld I found two samples and used them on a local web service but both of them did not get result s or generated an error. thanks

Mohammad Al Hoss Development To Me Is A Pleasure more than a Job

[Lost User]

Are you using MSXML2.XMLHTTP and TSQL, or are you using a CLR-sproc to read the webservice? If you're using the XMLHTTP variant, then you might want to check whether OLE-automation is enabled;

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

Hope this helps :)

I are Troll :suss: