Accessing SQL Server through a web page

  • Hi,

    I have a query regarding SQL Server. Currently I am using SQL Server 2005 Express and I have a couple of databases for various clients. This database is hosted on a machine locally. What I want is that I will be able to read and update data in this database from a web page on the internet. Is it possible? Maybe it is possible with the use of web services?

    If someone can help me I would be very grateful. Thanks in advance for your time.

  • rd_dart (5/2/2012)


    Hi,

    I have a query regarding SQL Server. Currently I am using SQL Server 2005 Express and I have a couple of databases for various clients. This database is hosted on a machine locally. What I want is that I will be able to read and update data in this database from a web page on the internet. Is it possible? Maybe it is possible with the use of web services?

    If someone can help me I would be very grateful. Thanks in advance for your time.

    This is a WIDE subject so here's the headlines:

    1. Yes, you can present / update / delete data from SQL 2005 Express

    2. The technology you need to research is ASP.NET, from Microsoft. Another product is Microsoft LightSwitch which is a rapid way of building simple read/update/delete web-apps from databases.

    3. Will the website be on the local machine? A local machine hosting on the net is fine but you must research security!!!!!

    4. Security!!!

    Good luck!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply