Re: Accessing SQL server db through the Internet...


"Atlas" <atlaspeak@xxxxxxxxxxx> wrote in message
news:12r9vg1ddq2sld4@xxxxxxxxxxxxxxxxxxxxx
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.


1. Yes you can access a SQL Server database remotely.
2. In all likelihood, it will be slower. Any time you cross networks, a
delay will be introduced. How this manifests itself can only be determined
by testing.
3. Whether it's hosted locally (to your application) or remotely won't
affect security.
4. You will find connection advice here:
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer

--
Mike Brind


.

Relevant Pages

  • Accessing SQL server db through the Internet...
    ... SQL Server 2000 over the Internet. ... ASP pages hosted by my ISP must load from db article abstracts ... but the DB is located elsewhere, so the ASP code must acces remotely the db. ... like exposing the db to the Internet? ...
    (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)
  • Re: Best Pratice-Remore ADO Access
    ... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
    (microsoft.public.vb.database.ado)
  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
Loading