Calling A Web Service

[gslick]

Hi

does anybody have and links to any resources that shows me how to connect to a web service from within SQL Server 2005.

I am just looking for some code (even if its using c# clr) that can link to the web service and call a web method.

Thanks

 

[onpnt]

You can look into using Broker

Or you can as you pointed out write a CLR procedure to do this. There may not be much out there for that type of setup though. I've never really checked on it but I have written CLR's to do this. You have to be very careful security wise of course sense your SQL Server will require external_access to make the calls. Broker was put in for just those types of tasks (and others). Some key things to remember with the CLR is the DB will need to be trustworthy along with external access granted to the owner of the assembly and the assembly of course will require a permission set of external access.



_{____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own}

 

[gslick]

Hi thanks for that.

I did look into using the Service Broker before i asked because I thought this was the logical choice, but it looks like you can only create a web service on a SQL box, but not call a webservice on an external box(unless I am mistaken)

You are correct, there isnt much info out there for this.

 

[onpnt]

Here are a few articles you may want to look into

http://www.devx.com/dbzone/Article/28525

http://www.developer.com/db/article.php/10920_3390241_1

http://www.builderau.com.au/archite...for-Web-services/0,339024590,320265422,00.htm

http://www.vsj.co.uk/xml/display.asp?id=512

Check the end point discussion in the last article

_{____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own}