> We get the following exception:

>  0x0000005 Access violation in ODBCCR32.DLL
> when we attempt to close a recordset (that we
> ensure is open).

> This is with VC++ V5 under NT 4.0 (using Oracle 7 or 8).

> It appears that the m_hstmt value is invalid
> when the call to SQLFreeStmt is called, causing the access violation.

> Thanks for any help!
> john

> void CRecordset::Close()
> {
>         ASSERT_VALID(this);
> .
> .
> .
> .
>         RETCODE nRetCode;
>         if (m_hstmt != SQL_NULL_HSTMT)
>         {
>                 AFX_SQL_SYNC(::SQLFreeStmt(m_hstmt, SQL_DROP));
>                 m_hstmt = SQL_NULL_HSTMT;
>         }

> This may not be your issue:  I used to get access violations if I created
> the CDatabase and CRecordset in the same scope.  When the CRecordset
> destructor was called, the CDatabase object may have already been deleted
> or invalid.
> I usually create CDatabase as a pointer member variable outside of the
> method where the CRecordset was created and destroyed.

> > Please help.

> > We get the following exception:

> >  0x0000005 Access violation in ODBCCR32.DLL
> > when we attempt to close a recordset (that we
> > ensure is open).

> > This is with VC++ V5 under NT 4.0 (using Oracle 7 or 8).

> > It appears that the m_hstmt value is invalid
> > when the call to SQLFreeStmt is called, causing the access violation.

> > Thanks for any help!
> > john

> > void CRecordset::Close()
> > {
> >         ASSERT_VALID(this);
> > .
> > .
> > .
> > .
> >         RETCODE nRetCode;
> >         if (m_hstmt != SQL_NULL_HSTMT)
> >         {
> >                 AFX_SQL_SYNC(::SQLFreeStmt(m_hstmt, SQL_DROP));
> >                 m_hstmt = SQL_NULL_HSTMT;
> >         }