How to close the cursor from MFC's CRecordset ??

From: Inge Korbu <ingek_at_ks-t.no>
Date: 19 May 1999 08:59:05 +0200
Message-ID: <uhfp9wnnq.fsf@ks-t.no>

Hi,

I'm using CRecordset (MFC, VC5.0), Microsoft ODBC for Oracle 2.573 and Oracle 8.0.5 for NT. My problem is that MFC/ODBC does not close the Oracle cursor in CRecordset::Close(). Seems like cursors are not closed before the database connection is closed! This eventually leads to "ORA-01000: maximum open cursors exceeded". Any solutions?
(It is too time consuming close the connection, and then reconnect, just to close cursors. Also I don't want to increase the maximum number of allowed cursors)

Thanks!

--
Inge Received on Wed May 19 1999 - 01:59:05 CDT