I hav oracle 9i installed on my server, and I am fireing a query as followsSelect distinct divisioncode from Mdivision Order By DivisionCodeWhen I fire this query in sql plus, it runs and give me results.but when I fire it thru asp script as follows rsDiv.Open sql,conn,3,1 while traversing thru the recordset on line if not rsDiv.EOF thenit is giving me following errorADODB.Recordset (0x800A0E78)Operation is not allowed when the object is closed.Pl. help me a.s.a.p.

Interview Candidate
Jan 9th, 2006
2
2373

Showing Answers 1 - 2 of 2 Answers

Prasad Meduri

Feb 13th, 2006

As soon as you open the recordset you cannot give if ....
use
while not rs.eof()
..................
................
rs.movenext()
................
.................
wend
try this

Jamuna.B

Feb 17th, 2006

Before traversing thru the table you can check the status of recordset ie whether it is open or closed.
if rsdiv.status=closed then
rsdiv.open............
end if
Try this.
Cheers,
Jamuna.B