Подключение к Access из консольного приложения MVS2012 и выборка данных c выводом в консоль

    CDaoDatabase db;
    db.Open(L"d:\\TestDB.mdb");
 
    CString sQuery = "SELECT Table_1.data FROM [Table_1]";
 
    CDaoRecordset rs(&db);
    rs.Open(dbOpenDynaset, sQuery);
 
    COleVariant oVar;
    rs.MoveFirst();
    rs.GetFieldValue(0, oVar);
    rs.Close();
    db.Close();
    cout << "Extracted: " << oVar.intVal << endl;

    CString sQuery = "SELECT Table_1.name FROM [Table_1] WHERE key = 'name'";

    cout << "Extracted: " << (LPCTSTR)(oVar.bstrVal) << endl;

cout << "Extracted: " << (LPCTSTR)V_BSTRT(oVar) << endl;

cout << (LPCTSTR)_bstr_t(rs.GetFields()->GetItem("Name")->GetValue()) << endl;

#include <iostream>
#include <conio.h>
#include <afxdao.h>
 
using namespace std;
 
int main()
{
    CDaoDatabase db;
    db.Open(L"TestDB.mdb");
 
    CString sQuery = "SELECT Table_1.name FROM [Table_1] WHERE key = 'name'";
 
    CDaoRecordset rs(&db);
    rs.Open(dbOpenDynaset, sQuery);
 
    COleVariant oVar;
    rs.MoveFirst();
    rs.GetFieldValue(0, oVar);
    rs.Close();
    db.Close();
    cout << "Extracted: " << (LPCTSTR)_bstr_t(rs.GetFields()->GetItem("Name")->GetValue()) << endl;
//    cout << 5 << endl;
    _getch();
    return 0;
}

    cout << "Extracted: " << (LPCTSTR)V_BSTRT(&oVar) << endl;

cout << (LPCSTR)V_BSTR(&oVar);

    std::wstring wtest(V_BSTRT(&oVar));
    std::string str( wtest.begin(), wtest.end() );

    ...
    cout << "Extracted: " << _bstr_t(oVar) << endl;
    rs.Close();
    db.Close();
    AfxDaoTerm();
 
    return 0;

#include <iostream>
#include <conio.h>
#include <afxdao.h>
#include <comutil.h>
#include <AtlBase.h>
#include <AtlConv.h>
 
using namespace std;
 
int main()
{
    CDaoDatabase db;
    db.Open(L"TestDB.mdb");
 
    CString sQuery = "SELECT Table_1.name FROM [Table_1] WHERE key = 'name'";
 
    CDaoRecordset rs(&db);
    rs.Open(dbOpenDynaset, sQuery);
 
    COleVariant oVar;
    rs.MoveFirst();
    rs.GetFieldValue(0, oVar);
    cout <<  _bstr_t(oVar) << endl;
    rs.Close();
    db.Close();
    AfxDaoTerm();
//  std::wstring wtest(V_BSTRT(&oVar));
//  std::string str( wtest.begin(), wtest.end() );//    
    _getch();
    return 0;
}