Re: Oracle / ASP / Interdev - Problems with Queries being executed on web server

For a bit more information, try
http://support.microsoft.com/support/kb/articles/q229/9/19.asp?LNG=ENG&SA=ALLKB .
Kurt

Mike O'Connor wrote:

> 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:37:27 CST