How to call a webservice from sqlserver2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to call a webservice from sqlserver2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-01-03 : 14:20:34

Bhanu writes "Hi,

My question is below.
I have a webservice and want to call that webservice from sql server 2000 using stored procedure or DTS. How can I do this ?
Any help is appreciated.

Thanks
Bhanu"

monty
Posting Yak Master

130 Posts

Posted - 2007-01-03 : 23:09:16

Hi if you are using MSSOAP30.SOAPCLIENT object created using sp_OACreate to make this call then you can create an object of XMLHTTP using sp_oacreate as

exec @hr = sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT

exec @hr = sp_OAMethod @obj, 'Open', NULL, 'GET', @sUrl, false

exec @hr = sp_OAMethod @obj, 'send'

its me monty

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources