Take a look at this code:
CoInitialize(NULL);
_ConnectionPtr m_pConn;
m_pConn.CreateInstance(__uuidof(Connection));
m_pConn->Open(_bstr_t("Provider=MSDASQL.1;Persist Security Info=False;Data Source=Probe"),_bstr_t(""),_bstr_t(""),adConnectUnspecified)...