RE:base de datos SQL Server
#include <afxwin.h> // MFC 6.0
#include <afxdb.h> // MFC 6.0
#include <stdlib.h>
// ...
CDatabase* pDBase = new CDatabase();
CString csDsn;
CString csSql;
csDsn.Format(_T("DSN=%s; UID=%s; PWD=%s"),TuOdbc, TuUser,
TuPassword);
csSql = _T("select CAMPO from TABLA");
pDBase->OpenEx(csSql.GetBuffer(0), AFX_DB_USE_ALL);
CRecordset* pRecordset = new CRecordset(pDBase);
pRecordset->Open(csSql.GetBuffer(0));
while (!pRecordset->EOF())
{
CString csTemp;
pRecordset->GetFieldValue(_T("CAMPO"), csTemp); // csTemp&
pRecordset->MoveNext();
cout << csTemp.GetBuffer(0) << endl;
}
pRecordset->Close();
pDBase->Close();
delete pRecordset;
delete pDBase;
// ...
/* Saludos */