TestODBC

    CDatabase db;
    db.OpenEx( _T( "DSN=orcl;UID=system;PWD=root" ));
    CRecordset rs( &db );
    rs.Open( CRecordset::forwardOnly,_T( "SELECT * FROM student" ) );
    CDBVariant varValue;
    short nFields = rs.GetODBCFieldCount( );
    std::cout<<"nFields "<    while( !rs.IsEOF( ) )
    {
       for( short index = 0; index < nFields; index++ )
       {
          rs.GetFieldValue( index, varValue );
          if(varValue.m_dwType==DBVT_ASTRING )
          {
             std::cout<<*varValue.m_pstringA<          }
          if(varValue.m_dwType==DBVT_WSTRING )
          {
              _tprintf(_T("%s/n"),*varValue.m_pstringW);
          }
       }
       rs.MoveNext( );
    }