John Baird
Coatesville, Pennsylvania, United States
I'm sorry, but this is waaaay beyond my simple knowledge. You might want to post this question in the general forum on the fox side. There are a lot of people there who are much more knowledgable than me.
>i have another question to go along with this because I get the same error using the code below.
>
>ado2.strSQL = "Select * From X Where y = 1"
>ado2.RetrieveReader()
>
>If ado2.objDR.Read() Then
>end if
>
>ado2.objdr.close
>ado2.closeconnection
>
>Regular VB6 apps do queries all day long against this oracle database and they never get the too many open cursors error. Why would the above code create an oracle cursor and not close it? Is this a .NET error? It just seems to me like I am writing the code I need to, but the cursor is not destroyed until my application ends. Could Session Pooling have anything to do with this and if so, how can I control it? Thanks again for the help.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only