Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Useless?

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-05-09 : 17:04:56
Is this of any interest/use to anyone?

[url]http://www.rdlcomponents.com/EXSP/Default.aspx?sm=a_a4[/url]

What exactly would you use it for? I'm not certain I know what a web service really is which means I'm not clear at all why I might want to connect my server to it

thanks

steve

A sarcasm detector, what a great idea.

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-05-09 : 18:29:14
WebServices are generally used for B2B communications.

An example of why you might use this would be an e-commerce application. Let's say your company sold widgets. You have a company you re-sell the widgets from, and they handle warehousing the widgets and shipping them. So, on the website where you go to show how many widgets are in stock, you might want to hit a webservice at your supplier and see how many they have in stock in real time. Personally, I'd do this in ASP.Net code and not in a stored proc, but you could do it that way.

Another application like this might be for ordering purposes. Maybe you have a stored proc that calculates inventory, and could then call a web service to order more widgets based on how many you need to fill your orders.

Something along those lines. I'm not sure that I'd ever give my SQL Server access to the internet, but you could do it.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-05-10 : 02:59:03
That's very helpful thanks Michael

quote:
I'm not sure that I'd ever give my SQL Server access to the internet, but you could do it.


I couldn't agree with you more on this one


steve

A sarcasm detector, what a great idea.
Go to Top of Page
   

- Advertisement -