NA

NA

  • NA
  • 1
  • 0

Connecting a web service to upload into a database. Is this possible?

Apr 5 2007 2:31 PM

Is there a way too connect a web service's information to a MS SQL 2005 server database?

  

For example say a database has a select statement that takes all the stock symbols from a table and then uses the web service to get the stock symbol closing price data. When the web service gets the data it executes a procedure to update the data into a table. This process is done once a day after the markets close say 6pm Eastern Standard Time.

 

Is there a way to do this I would like to now how to do this because I think telling a  web service what to get from a database and then having the XML uploads go directly to a database would be a great tool to use in my database.

Thank you in advance for your help.

PR