Re: Where is the result Set in ODBC

From: Tim Haynes <thaynes_at_openlinksw.co.uk>
Date: Thu, 15 Oct 1998 12:14:47 GMT
Message-ID: <704ovn$kqu$1@nnrp1.dejanews.com>

Hi,

Depends on your driver. If you're using a client-only (single-tier) driver relying on something like SQL*net, all the processing and result-set storage is on the client. OTOH if you have a proper multi-tier driver with server components, the storage and processing can be left to the server.

If you need an example of an MT driver, check out OpenLink - http://www.openlinksw.co.uk/ onwards.

Regards,

~Tim

In article <701m02$384$1_at_phys-ma.sol.co.uk>, "Bill Buchan" <bbuchan_at_ossian.net> wrote:
> I'd be grateful if somebody could clear this up for me. Where is the result
> set for a query held when accessing the server across the network? Is it in
> the PA or on the client? If it is in the PA, do I have to make a network
> call overtime I advance the cursor?
>
> Any information gratefully received!
>
> Thanks,
>
> - Bill
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 15 1998 - 07:14:47 CDT