Problem Accessing Oracle8 Using ODBC

    I was trying to write a MFC program to read & update a table in Oracle 8 v8.0.3 using ODBC. I got an error "ODBC static cursors required for snapshot support" when I was trying to do the following:

void COption::Change(CDatabase* pdb)
{

      this->m_strFilter.Format("Id = '*01'");     /* Where */
      this->Open(CRecordset::snapshot, "[TTABLE]"); /* Declare cursor */

    The COption is an CRecordSet object. The problem occured in the "Open". The connection to the database prior was OK. I wonder what was the problem. Thx in advance. Received on Mon May 25 1998 - 00:00:00 CEST