Re: Oracle access via EXCEL

In article <wmeahan.226.000D4EA6_at_ef0424.efhd.ford.com> wmeahan_at_ef0424.efhd.ford.com (Bill Meahan) writes:
>From: wmeahan_at_ef0424.efhd.ford.com (Bill Meahan)
>Subject: Re: Oracle access via EXCEL
>Date: Fri, 4 Nov 1994 13:18:20
 

>In article <786562889wnr_at_zentor.demon.co.uk> neilw_at_zentor.demon.co.uk (Neil Washbrook) writes:
>>Can any one help me with a follow up to this discussion. I understand
>>the concepts etc of ODBC. I have a client that is running Oracle on a
>>mini and wants access to the data from his PC, however he does not
>>want the associated network traffic of carrying out the SQL query on his PC.
>>Is there a method of generating an SQL query on the PC, sending it to
>>the mini, running it there and extracting the information back into
>>something like an Microsoft Access Table to allow him to do local analysis on
>>his PC?
 

>This is probably an order of magnitude MORE network traffic!
 

>If you use ODBC in the "passthru" mode, the SQL statement gets snet to the
>host, and only the result set is returned to the PC. What you are proposing
>sounds like it would copy the entire table from Oracle to Access (which
>happens sometimes anyway thanks to Access' low-IQ query engine) to then
>extract the result set. If your typical result set is smaller than the entire
>table, you save big time by letting the host do the processing! Plus, you
>take advantage of the higher-performance of the host to do the actual query
>processing.

You don't have to use the pass through option. Oracle's ODBC driver is not going to process the SQL locally, it is going to send it to the host. The important thing is to format a SQL statement that only returns the set that is of interest.

>--
>Bill Meahan, Senior Developer | wmeahan_at_ef0424.efhd.ford.com
>Electrical & Fuel Handling Division, Ford Motor Company
>Opions expressed herein are those of the author and in no way represent
>any official statement or opinion of Ford Motor Company
Received on Thu Nov 10 1994 - 23:27:17 CET