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)
 Getting data from and to sql over the web

Author  Topic 

mabelis
Starting Member

2 Posts

Posted - 2011-08-12 : 08:47:32
I apologize up front if this question is too basic for this forum; I'm just hoping for someone to give me some clues. What i need is a way to get data from and to a SQL-server using http. Up till now, the application uses the RDS datafactory object for this - to our complete satisfaction, I may add. But now our old windows2003 server has to be replaced and I read RDS is out; I have to use 'WCF data services' and 'Odata' - then got lost in a staggering amount of info which made me wonder if my simple problem is gonna take a month of study...

I only need a way to get a recordset from the server, and subsequently submit a number of updates and insertions to the server. (could easily generate a sql-script for those, for instance).
Like many old people (I started programming 20 years ago) I feel like a newbee when confronted with the daunting possibilities of the new methods I read about. So, I'm hoping someone here can give me a few hints on how to start. I'd be most grateful.
Hans
   

- Advertisement -