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: 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)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... enable network communication ... make sure that the port isn't blocked ... "An error has occurred while establishing connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.sqlserver)
  • Re: Cannot connect to SQL express database ????
    ... However, yes, you are correct that if SQL Server Express Edition is using dynamic ports, then the port could change to one that is blocked by the firewall. ... This connection string using sytax ... >>> I can manage without any problem my database from the VIsta ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... Check the logs for the EXPRESS instance to see what port it ... But I have another 2000 server that I can connect to fine, ... Can someone help me with a connection problem! ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.sqlserver.connect)