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

Question

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

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

KCSNirav SSC Enthusiast Points: 134 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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]