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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle / ASP / Interdev - Problems with Queries being executed on web server

From: David Oxley <newsmail1_at_planetzog.co.uk>
Date: Wed, 2 Feb 2000 22:47:24 -0000
Message-ID: <87ac55$ao7$1@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 Wed Feb 02 2000 - 16:47:24 CST