C++ ADO

#import "D:\Program files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","rsEOF")

void CAdoDlg::OnBtnQuery() 
{
	CoInitialize(NULL);
	_ConnectionPtr pConn(__uuidof(Connection));
	_RecordsetPtr pRst(__uuidof(Recordset));
	try
	{
		pConn->ConnectionString="Provider=SQLOLEDB.1;Initial Catalog=pubs;Trusted_Connection=yes";
		pConn->Open("","","",adConnectUnspecified);
		pRst = pConn->Execute("select * from authors",NULL,adCmdText);
		while(!pRst->rsEOF)
		{
			((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->GetCollect("au_lname"));
			pRst->MoveNext();
		}
		pRst->Close();
		pConn->Close();
	}
	catch(_com_error e)
	{
		char buff[100];
		strcpy(buff,(const char *)(e.ErrorMessage()));
		MessageBox(buff);
	}
	pRst.Release();
	pConn.Release();
	CoUninitialize();
}