Getting the Error:[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation [Archive]

Velayutham

05-23-2000, 12:09 AM

I am having a table which is having a 50,000 records. If I try to retrieve
10 records
from the table I am getting the followig error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

bug.asp, line 20 (i.e in the rs.open statement)

I am getting the above error exactly after 30 seconds.

I have checked with the Oracle documentation the error says that the user
has pressed the
CTRL+C

I have not done anything. I think so the IIS has fired the key.

I am using the following configuration:

WinNT 4.0,IIS 4.0, Oracle 8i(8.1.5), Windows 98 Nodes,IE5.0 is the browser.
Session Timeout 20 minutes
ASP Script timeout 90 seconds
I am using Oracle ODBC Driver for dsn connection.

The following is the source code.

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>

<%
Dim rs,sql,dsn
set rs = server.createObject("ADODB.Recordset")
sql = " SELECT to_char(CLIENT.ID) ID, "&_
" DPM_CLIENT_ID, "&_
" FIRST_HOLDER_NAME "&_
" FROM CLIENT "
dsn = "dsn=oracleserver;uid=dp2000;pwd=dp2000;"
rs.activeconnection = dsn
rs.cursorlocation = 3
rs.cursortype = adopenstatic
rs.source = sql
rs.open
rs.activeconnection = nothing
rs.pagesize = 10
rs.MoveFirst
Response.Write("<br>")
Response.Write("Client Name")
Response.Write("<br>")
For i = 1 to 10
Response.Write(rs.Fields("FIRST_HOLDER_NAME"))
Response.Write("<br>")
rs.MoveNext
Next
%>
</BODY>
</HTML>

Can Any One help me.

I will be greatfull.

Thanking You.

Regards

S. Velayutham