mdb를 이용한 ado 예제

프로그래밍 2009. 4. 27. 09:56

Nwind.mdb

#include <IOSTREAM>

#import "c:\Program Files\Common Files\system\ado\msado15.dll" rename("EOF", "adoEOF")

int main(int argc, char* argv[])
{
    CoInitialize( NULL );               // COM 초기화

//_ConnectionPtr pAdoCon(__uuidof(Connection));
    //_CatalogPtr pCatalog(__uuidof(Catalog));

ADODB::_RecordsetPtr pAdoRs;
    pAdoRs.CreateInstance(__uuidof(ADODB::Recordset));

_bstr_t bstrSqlConn =   "Provider=Microsoft.Jet.OLEDB.3.51;Password=\"\";Data Source=Nwind.mdb;Persist Security Info=True";
    _bstr_t bstrSQLText =   " SELECT * FROM Employees";

try
    {
        HRESULT hResult = pAdoRs->Open(bstrSQLText, bstrSqlConn, ADODB::adOpenForwardOnly, ADODB::adLockReadOnly, ADODB::adCmdText);
        if (SUCCEEDED(hResult))
        {
            std::cout << "SUCCEEDED" << std::endl;
        }

while (!pAdoRs->adoEOF)
        {
            _bstr_t name    = pAdoRs->Fields->Item["FirstName"]->Value.bstrVal;
            long    Id      = pAdoRs->Fields->Item["EmployeeID"]->Value.lVal;
            _bstr_t xtype   = pAdoRs->Fields->Item["LastName"]->Value.bstrVal;
 
            std::cout << (char*)name << " : " << Id << " : " << (char*)xtype << std::endl;
 
            pAdoRs->MoveNext();
        }
        pAdoRs->Close();
        
        pAdoRs = NULL; // Release
    }
    catch (_com_error& e)
    {
        std::cout << "------------------------------" << std::endl
            << "ADODB Error" << std::endl
            << "------------------------------" << std::endl
            << "Error Code : " << e.Error() << std::endl
            << "Source : " << (char*)e.Source() << std::endl
            << "Description : " << (char*)e.Description() << std::endl
            << "------------------------------" << std::endl;
    }

CoUninitialize();                   // COM 해제

return 0;
}