Time out error in ASp

[Itopa]

Hello, I ran my asp pge on small records and it came out fine but when i change the criteria for all records i get this error


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation


Pls what do i need to do to make it run without breaking. I have increased the script time out value though

Thanks

 

[DotNetGnat]

can you show us your query...you need to set oracle odbc time out settings too...

-DNG

 

[Genimuse]

You probably should optimize your code, too. If you're using an open recordset with MoveNext, for example, you're burning many times more cycles than you would with GetRows(), which runs many times faster than moving through a recordset.