Post reply

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

  • 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

  • May 28, 2012 at 1:44 am

    This was removed by the editor as SPAM

  • 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.

  • May 28, 2012 at 3:01 am

    This was removed by the editor as SPAM

  • 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

  • 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]

  • May 28, 2012 at 8:33 am

    This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply