C / C++ / MFC

_RecordsetPtr pRecordset = NULL;

// Create COM instance. You should also test the return code for
// this for success.
pRecordset.CreateInstance(__uuidof(Recordset));

//
// etc. etc..

void ConnectAndDisplay()
{
	CString strSQL;				// SQL statement string
	_variant_t vtAffected;			// 
	_variant_t vtField;			// 
		
	_ConnectionPtr pConnection = NULL;	// connection smart pointer
	_RecordsetPtr pRecordset = NULL;	// recordset smart pointer

	strSQL = "Select [Name] From [CustomerTable]";

	try
	{
		TESTHR( pConnection.CreateInstance(__uuidof(Connection)) );
		TESTHR( pRecordset.CreateInstance(__uuidof(Recordset)) );
		TESTHR( pConnection->Open( _bstr_t(_T("File \\MyConnection.udl;")), "", "", NULL ) );

		// Execute pre-prepared SQL statement
		pRecordset = pConnection->Execute((LPCTSTR)strSQL, &vtAffected,adOptionUnspecified);

		// display returned results
		while( pRecordset->ADOEOF != VARIANT_TRUE )
		{
			_variant_t vtField;
			CString strField;

			vtField = pRecordset->Fields->GetItem("Name")->Value;
			/////////////////////////////////////////
			ASSERT( vtField.vt == VT_BSTR );		// we are expecting a string!!
			////////////////////////////////////////
			strField = vtField.bstrVal;

			cout<< (LPCTSTR)strField << endl;
			pRecordset->MoveNext();
		}

		pConnection->Close();
	}
	catch(_com_error e)
	{
		CString strMessage;
		strMessage.Format("Error: %s\n", e.ErrorMessage());
		AfxMessageBox(strMessage);
	}
	return;
}

CString str;<br />
str.LoadString(IDS_MYSTRING);<br />
// str now the text from IDS_MYSTRING in it