Maximum Open Cursors Exceeded ?? - HELP 1

[krpd]

Hi,

I am working on a VB - Oracle application. I get this error "Maximum Open Cursors Exceeded", when ever i query for different records more than 25-30 times. Since this is a multiuser App. I am using a DYNAMIC cursor for all operations and a STATIC cursor for display only. ( - basically opening ADO Recordsets thru code)

I am not sure how to CLOSE a cursor, or does it implicitly get closed in
VB when the RECORDSET is closed or SET equal to NOTHING ??

How do i know whether a cursor is Closed or not ??

Please help ...

Prabhu Dev

 

[MatsHulten]

Dont know if this will help, but try it!

set rs = con.execute(sql)

do while not rs.eof
   ...
next

rs.close
set rs = nothing

set rs = new adodb.recordset

Good Luck
-Mats

 

[krpd]

Hi,
Mats,

Thank You for the reply,

I am doing the same thing, however the error occurs. Is there anything i need to do at the backend, to ensure the Cursor is closed(destroyed) after the query is completed ??

Prabhu Dev

 

[chiph]

Nope.
Just close the recordset, then set the variable to nothing. ADO/OLEDB/Whatever should then release the cursor.

Hmmm. Have you tried (as an experiment) forward-only cursors?

Chip H.

 

[MatsHulten]

Are you using the same connection object for all your recordsets?
If not, do so. This may be a problem with to many connections to the same DB. (One connection object can sustain many recordsets.)

Good Luck
-Mats