Xref: alice comp.databases.oracle.misc:52399
Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!newsfeeds.belnet.be!news.belnet.be!skynet.be!diablo.theplanet.net!btnet-peer!btnet!mendelevium.btinternet.com!not-for-mail
From: "David Oxley" <newsmail1@planetzog.co.uk>
Newsgroups: comp.databases.oracle.misc,microsoft.public.inetserver.asp.db,microsoft.public.vinterdev
Subject: Oracle / ASP / Interdev - Problems with Queries being executed on web server
Date: Wed, 2 Feb 2000 22:47:24 -0000
Organization: BT Internet
Lines: 22
Message-ID: <87ac55$ao7$1@uranium.btinternet.com>
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

Hi..

I have a large Oracle Database that I wish to interrogate for simple
searches by means of a web interface.

I am using IIS4 and I am currently evaluating MS Interdev with ASP... I am
using ODBC drivers with a System DSN to communicate with the database.

The trouble occurs when I execute a Select Query..

When I execute the command
Select * From PEOPLE Where Surname = "Smith"

the whole PEOPLE table seems to be transferred across the network to the web
server and the query is performed there... Obviously this makes response
times far too slow..

Is there a way of forcing the query to take place on the Oracle machine????

All Help Appreciated