Using SQL server 2008 call asp.net web service from store procedure and get responce

• KCSNirav

  SSC Enthusiast

  Points: 134

  More actions

  May 27, 2012 at 10:30 pm

  #257043

  Hello All,

  How to call asp.net web service from SQL server 2008 store procedure and get response from web service in store procedure.

  Please help me.

  Thanks & Regards,

  Nirav

• KCSNirav

  SSC Enthusiast

  Points: 134

  More actions

  May 28, 2012 at 2:37 am

  #1493668

  Hello,

  Thank you for your quick response.

  Without CLR method is it possible to direct call API or web service from sql server 2008 and get revert response.

• KCSNirav

  SSC Enthusiast

  Points: 134

  More actions

  May 28, 2012 at 4:00 am

  #1493694

  Hello Stewart,

  I had tried this example and it worked proper but how to get response from that URL.

  For example,

  My URL is http://localhost/SampleSite/Default.aspx.

  When i called from sql server i got the output "1". If URL was wrong then got the output "0". This mean URL is not proper.

  Now my requirement is that after call URL, URL will give return response like ("True" / "False") from URL side.

  Thanks & Regards,

  Nirav Parikh

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 28, 2012 at 8:28 am

  #1493818

  Stewart:

  Actually, the site at your link has another link to this site: (http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx) which does demonstrate a way to do it entirely from within SQL using OA Automation objects.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]