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.
Randy Belcher
AFG Industries, Inc.