Re: Recommended Approach

From: Don Grover (dgrover_at_assoft.com.au)
Date: 11/10/05 

Date: Fri, 11 Nov 2005 08:47:37 +1100

Not that I have put too much thought into it but here is a possible
solution.
Have the vb6 app do a xmlhttp post to your web server and have it do the
request for subscription date.
Then depending on what is returned you can download an update or not.

Don

"Dan Johnson" <johnson@milehi.com> wrote in message
news:5660$437357ed$d826dfe9$15934@VIAWEST.NET...
> Our company has a web site hosted by a third party with a connection to
> our
> SQL Server. The SQL Server resides locally behind the company's firewall.
>
> We write software and would like to have our app (written primarily in
> VB6)
> occasionally get small amounts of data from our SQL Server. For example,
> when the customer/user wants to get the most recent update to our
> software,
> we would want to retrieve the effective date of the user's subscription to
> make sure they qualify for the update.
>
> It is my understanding there are two approaches to doing this. One, we
> can
> make a direct ADO connection from the user's PC to our SQL Server. Two,
> we
> could (using RDS???) use our web sites connection to process the data
> request, and return whatever info to the user's PC.
>
> Both alternatives require opening up a port on our firewall to allow SQL
> access (good, bad, ugly???). I would tend to think that using the first
> alternative is preferable because it seems more efficient (if we're going
> to
> open up the port, may as well streamline the user's connection as much as
> possible...).
>
> Can anyone point me in the right direction for analysis here? Would be
> greatly appreciated!
>
> Thanks
>
> Dan
>
>

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... I believe the complete Windows auth user access is too complicate, ... which trusted connection is meant? ... it would still be listening on the old port. ... Microsoft, SQL Server Books Online ...
    (microsoft.public.sqlserver.connect)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: Proxy + ADO + VB6...
    ... When I'm on some customer running proxy behind, the VB6 app does not connect ... On IE when is proxied connection shows the server IP to ... the VB6 app can not reach the external SQL SERVER port 1433... ...
    (microsoft.public.vb.general.discussion)
  • Re: Sql Remote Connection issue
    ... port 1433 TCP Allow ... Copyright 2006 Microsoft Corporation. ... osql does not support all features of SQL Server 2005. ... Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2005 Connection Problems
    ... - it is't completely clear what the SQL Server Browser is for. ... connection reqest was being rejected. ... I think the problem is still likely the the port is blocked by some ... firewall between the server and that client. ...
    (microsoft.public.sqlserver.setup)