I have created asmx services on insert trigger. its successfully working also.
after that i have added security for asmx services.
i created below code and its working successfully.
set @URL=N'http://localhost/Test/WebService1.asmx/Frm_SendNotification?LsM_Message='test'
EXEC @rc = sp_OACreate 'MSXML2.ServerXMLHTTP', @objServHTTP OUT
EXEC @rc = sp_OAMethod @objServHTTP, 'open', NULL, 'GET', @URL
EXEC @rc = sp_OAMethod @objServHTTP, 'send'
EXEC @rc = sp_OADestroy @objServHTTP
but how to pass asmx username and password
Thanks
Basit.
Chetan RanpariyaPosted Jan 2, 2017, 5:25 AM