Re: Recommended Approach

From: Dan Johnson (johnson_at_milehi.com)
Date: 11/10/05

  • Next message: Jeff A. Stucker: "Re: SQL Service security" 
    Date: Thu, 10 Nov 2005 15:08:23 -0700

    Thanks for your reply Don.

    Any suggestions for where I can see how an "xmlhttp post " is done?

    Dan

    "Don Grover" <dgrover@assoft.com.au> wrote in message
    news:%23CKTgBk5FHA.1140@tk2msftngp13.phx.gbl...
    > 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
    > >
    > >
    >
    >

  • Next message: Jeff A. Stucker: "Re: SQL Service security"

    Relevant Pages

    • Re: Error "SQL Server does not allow remote connections"
      ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Connection from remote computer to network SQL Server
      ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
      (microsoft.public.access.adp.sqlserver)
    • ADO.net Orcas Samples Install Problem
      ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: OpenDataSource SQL Server xpress problem
      ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Exception trying to import data from Excel .
      ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
      (microsoft.public.sqlserver.tools)