Re: SSL/Response Object/data to client

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mark Schupp (nospan_at_nospam.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 12:58:22 -0800

Have you tried saving in XML format as the following example does?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdhowstep3senddata.asp

also try just echoing the raw data from within the vb app to see what is
actually being sent (use XMLHTTPRequest to get data instead of recordset). 

-- 
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Stefan Berglund" <keepit@in.thegroups> wrote in message
news:kc6u319jg3ojl1sqchc2k1rhpiihc6u496@4ax.com...
> This may not be the right group for this since the ASP part of the
equation
> seems to be working as it should, but at the very least perhaps someone
will
> point me to the correct group or even better, a solution.
>
> I've been using the following technique to return a recordset from a web
based
> SQL Server to my app.
>
> ASP (no HTML):
>
> <%Option Explicit%>
>
> <!--#include file="inc/asp_head.asp" -->
> <!--#include file="inc/asp_connect.asp" -->
> <%Dim rs: Set rs = cn.Execute("get_SomeData " &
> LikePhrase(ValidateInputString(Request.QueryString("ShowTitle"),"")))
>   rs.Save Response: rs.Close: Set rs = Nothing: cn.Close: Set cn =
Nothing%>
>
> VB app:
>
>   rs.Open "http://" & frmMain.IP_Main & "/someASP.asp?ShowTitle=" &
> URLEncode(frmMain.ShowTitle)
>
> At this point the app can use the recordset that was passed
> through the Response object just like any other recordset.
>
> The problem comes about when attempting to use https in place of http.  As
I
> said, the ASP shows every indication of working since I can see the data
in a
> browser window but the recordset is empty/non-existent in the client app.
I've
> tried the URL= as in rs.Open "URL=https://... and found docs that seem to
> indicate that this worked in the days of RDS, but I've been unsuccessful
in
> googling anything appropriate.  Can anyone shed any light on this or offer
an
> alternative methodology to obtaining data securely from the Internet?
>
>
> ---
> Stefan Berglund

Relevant Pages

  • SSL/Response Object/data to client
    ... I've been using the following technique to return a recordset from a web based ... SQL Server to my app. ... ASP: ... The problem comes about when attempting to use https in place of http. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Access 2007 - Anyone having trouble with really large conversions?
    ... I have a fairly large app, ... program, which has added even more forms, queries and linked tables. ... get errors when opening a recordset for a linked table. ... So Access 2007 always seems to use Recordset2 objects for its forms and reports ...
    (comp.databases.ms-access)
  • Re: Datareader, dataset, else?
    ... A DataReader is most closely analogous to a Read-Only/Forward-Only Recordset ... > I'm writing my first real asp.net app at my job, ... > seems like I have to choose between using a SQldatareader or a dataset. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Application crashes with "On Error Resume Next"
    ... The code is intended to move data from one recordset to another - ... however the "ChangedCarveOuts" recordset is built using a stored proc ... Next is then to allow the app to skip any potential 3065 (Item cannot ... ran the app on a machine at the client site that uses MDAC ...
    (microsoft.public.vb.bugs)
  • Re: Accessing External data
    ... I need to save data from an Access APP with no TABLES ... The values of the subform's controls TAG need to be saved / loaded. ... The MASTER Form and the rest of the APP looks at CONstants - which I'd like ... I'm struggling to create a recordset here ...
    (microsoft.public.access.modulesdaovba)