Returning ADO recordset over the internet from ASP

[Mike Collier]

Hi,

I remember seeing (a long time ago) an ADO code snippet that would query a
local database (Access) and return the result as an ADO recordset that could
be loaded into a client side VB application....

Can someone point me in the right direction, I found plenty of sites that
display data in HTML, but none that "stream" the data back as I remember
it....

Thanks in advance

--
Mike Collier
[url]http://www.adoanywhere.com[/url]
[url]http://www.adoanywhere.com/forum[/url]

[Bob Barrows]

Mike Collier wrote:

> Hi,
>
> I remember seeing (a long time ago) an ADO code snippet that would
> query a local database (Access) and return the result as an ADO
> recordset that could be loaded into a client side VB application....
>
> Can someone point me in the right direction, I found plenty of sites
> that display data in HTML, but none that "stream" the data back as I
> remember it....
>
> Thanks in advance

Here's one way to do it
[url]http://www.davidpenton.com/testsite/tips/xml.recordset.server2client.asp[/url]

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Mike Collier]

Thanks Bob,

I don't suppose you know the client side aspect of this in ADO do you?

IIRC there was a way of specifying the asp page in the SQL text of an ADO
recordset object (i know that sounds strange)..

--
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
[url]http://www.adoanywhere.com/forum[/url]



"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OtFzedr2DHA.1700@TK2MSFTNGP12.phx.gbl...

> Mike Collier wrote:

> > Hi,
> >
> > I remember seeing (a long time ago) an ADO code snippet that would
> > query a local database (Access) and return the result as an ADO
> > recordset that could be loaded into a client side VB application....
> >
> > Can someone point me in the right direction, I found plenty of sites
> > that display data in HTML, but none that "stream" the data back as I
> > remember it....
> >
> > Thanks in advance

>
> Here's one way to do it
> [url]http://www.davidpenton.com/testsite/tips/xml.recordset.server2client.asp[/url]
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Bob Barrows]

This probably cannot be done in client-side code, but I've never tried it in
server-side code either, so I am not sure. All you can do is try.

FWIW, this can get a little tricky security-wise. If you keep all your
database access code server-side, security is a lot easier.

You can use the XMLHTTP object in client-side code to retrieve data from
another asp page. Here's a demo which demonstrates this (the dynamic listbox
demo):
[url]http://www.thrasherwebdesign.com/index.asp?pi=links&hp=links.asp[/url]

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From header is
my spam trap, so I don't check it very often. You will get a quicker
response by posting to the newsgroup.
"Mike Collier" <mike@adoanywhere.com> wrote in message
news:%23XMsfZ72DHA.3416@tk2msftngp13.phx.gbl...

> Thanks Bob,
>
> I don't suppose you know the client side aspect of this in ADO do you?
>
> IIRC there was a way of specifying the asp page in the SQL text of an ADO
> recordset object (i know that sounds strange)..
>
> --