Web services????

Hi,

I have just spoken to a client who has an SQL Server 2000 setup in his office and would like people to be able to log into a website in the public domain and view some of these details.

At firat I thought about setting up a second SQL Server database on the web server and linking the 2 using the web servers database as a web back end.

I have recently read about web services/soap and was wondering if instead of using a second sql server I could create a webservice instead.

Is this a good/feasable solution? and if so can anyone reccomend a good starting point for a newbie in this field ?

Any Sites,Newbie books e.t.c

Thanks a lot

If you are interested in using SOAP to connect to your database, you have some studying to do regarding XML. www.w3schools.com is a good place to start. Most of the XML tutorials will relate to what you are trying to do.

Otherwise, you can use the same SQL server database that you are already using if it is networked to the web server. If security is an issue, though, it would probably be best to load a second SQL server and import the data from the existing database.

Hope this helps!