Accessing SQL server db through the Internet...

Hi there I'm wondering if it does make any sense to access data from a MS
SQL Server 2000 over the Internet.

ASP pages hosted by my ISP must load from db article abstracts (10 per page)
but the DB is located elsewhere, so the ASP code must acces remotely the db.

1) Is it possible?

2) Does it makes any sense, or it will be very slow?

3) Any drawbacks, like exposing the db to the Internet? (Risks)

4) How do you acheive that? Code sample.

Thanks to anyone wishing to help

Regards!


.

Relevant Pages

  • Re: Accessing SQL server db through the Internet...
    ... ASP pages hosted by my ISP must load from db article abstracts (10 per ... page) but the DB is located elsewhere, so the ASP code must acces remotely ... like exposing the db to the Internet? ... Yes you can access a SQL Server database remotely. ...
    (microsoft.public.inetserver.asp.db)
  • Question ()
    ... My handelhand is not always connected to the internet ... 1- I can use the ASP .NET my application should access a SQL ... server CE and sometimes SQL server on the internet? ... 2- What is the equivalent to the IIS on a pocket PC? ...
    (microsoft.public.dotnet.framework.aspnet.mobile)
  • License Question
    ... then keep with user licences. ... If your application is going onto the internet then you ... We plan to use sql server as the database ... back end for an ASP ...
    (microsoft.public.sqlserver.server)
  • Creating my first intranet site/application using ASP and MS Access
    ... I have just learnt some basic asp at uni and would like to ... employer. ... to the site/application (these machines will have Internet ... I will be installing IIS on my ...
    (microsoft.public.inetserver.iis.security)
  • Re: Getting Started
    ... assigned to your router. ... If you are using NAT to hide your internal ... are lots of books available on developing ASP or ASP.NET applications. ... So now they want an internet application. ...
    (microsoft.public.inetserver.iis)
Loading