Yea, use a stored procedure.
David Oxley <newsmail1_at_planetzog.co.uk> wrote in message
news:87ac55$ao7$1_at_uranium.btinternet.com...
> 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
>
>
Received on Thu Feb 03 2000 - 00:04:18 CST
