error in accessing large database through ASP

Hi,

I've made an ASP application with Oracle 8.1.6 as backend. This application was working fine until the database grew in size. To be more precise, the no. of records in two main data tables have increased from 7,000 to 160,000 approx.
Now almost every query run through ASP pages and accessing any of these tables results in following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Oracle][ODBC]Option value changed.

Although sometimes these pages execute succesfully but that is 3 out 10 cases. Any query not involving any of these two tables, runs successfully via ASP. More surprisingly, I didn't encounter any problem in executing these queries through Oracle client.

Any suggestions, what could be the possible causes?

Thanks,
Anand Received on Thu Aug 29 2002 - 12:29:16 CEST