Re: Web-based software update

From: Lauchlan M (LMackinnon_at_NOSPAMHotmail.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 18:15:57 +1000

> Is there a way to do software updates using a web-based interface?

Yes

> I have to
> access my SQL Server using the internet but unfortunately it is behind a
> firewall and therefore cannot be accessed directly from a Delphi
> application. Any help is greatly appreciated.

Well, any web application framework can access your database behind a
firewall. So EWF, IW and ASP.NET are obvious starter candidates.

But depending on what you want to do, you might instead really want to code
an n-tier application over the internet, in which case you might want to
look at n-tier solutions such as RemObjects/Data Abstract, or kbmmmw.

Or, with some database servers such as NexusDB, I think you can make them
work over port 80 anyway and hence go through firewalls (I am not sure about
this solution though, and I personally don't think it's the wisest thing to
do but I believe it's possible and not hard to do. Some people do it.). Not
sure if MS SQL Server can do this or not. I am not familiar with how you
would set it up to expose it directly on a given port and IP address.
Probably MS have the good sense by now not to let people do this, as they'd
get the security flack for it! <g>.

It really depends on what you need to do with your database and what you
want from it. You might end up writing a web application, a web service or
an n-tier application. So it really depends what you want to do.

But I gave you a few options! <g>

Lauchlan M

Relevant Pages

  • Re: Database/WebAccess
    ... > remote internet database question. ... > With SQL server you can define a Linked Server and write the necesssary ... >> out changes ona local database then upload to the server or would I be ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: SQL CE Setup 101... C#
    ... the Internet Url. ... We have seen issues when we give IP address in internet ... Try using the sql server instance name. ... > // Create the Local SSCE Database subscription. ...
    (microsoft.public.sqlserver.ce)
  • Re: Best way to communicate over net?
    ... SQL Server has things like 'round robin' so if you've got 4 people ... Besides I would need to constantly check the database for changes - as ... Internet, however I have no idea how to go about this. ... (not scanning an ftp directory on intervals). ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access via internet?
    ... I have a PC app that needs ... to access a database in another factory. ... database to access via the internet so that the app ... >a static IP address at the host (thats when the SQL Server is reachable ...
    (microsoft.public.sqlserver.msde)
  • Re: Web-based software update
    ... I would really like to use a desktop application accessing an MS SQL ... database remotely but the security issues has dampened this project of mine. ... > an n-tier application over the internet, in which case you might want to ... > sure if MS SQL Server can do this or not. ...
    (borland.public.delphi.thirdpartytools.general)