Home » SQL & PL/SQL » SQL & PL/SQL » ASp-Oracle "Cursor not ready for I-O" error
ASp-Oracle "Cursor not ready for I-O" error [message #21111] Fri, 12 July 2002 11:20 Go to next message
Narsi
Messages: 5
Registered: July 2002
Junior Member
Hi ,
I am connecting to Oracle from ASP pages using OO40 connectivity. I am doing an simple insert into a table and code goes thus

mySQL = "Insert into gets_gs_cd_dept(DEPT_NO,PROD_DESC1,PROD_DESC2,PROD_CODE) values(" & department

mySQL = mySQL & ",'" & description1 & "','" & description2 & "','" & prodCode & "')"

set rstemp=OraDatabase.dbCreateDynaset(mySQL,Cint(0))

I get an error

Oracle Automation error '800a01b8'

OIP-04116: Cursor not ready for I-O

Can anyone tell me where I am going wrong.

TIA
Narsi

Report message to a moderator

Re: ASp-Oracle "Cursor not ready for I-O" error [message #21728 is a reply to message #21111] Mon, 26 August 2002 09:37 Go to previous message
sri
Messages: 154
Registered: February 2000
Senior Member
when using automation server to insert a record the syntax shoul not be
conn.createdynaset(sql,0) instead you should say
conn ExecuteSQL sql.. try this

Report message to a moderator

Previous Topic: optimisation of query
Next Topic: Query Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 17 22:13:27 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.