C++使用ADO连接SQLSERVER

#include <string>

//c:\Program Files\Common Files\System\ADO\msado15.dll
#import "msado15.dll" no_namespace rename("EOF", "EndOfFile") 
using namespace std;

int _tmain(int argc, _TCHAR* argv[])
{
    ::CoInitialize(NULL); 
    _ConnectionPtr m_pConnection=NULL;
    _RecordsetPtr m_pRecordset=NULL;
    m_pConnection.CreateInstance(__uuidof(Connection));
    m_pRecordset.CreateInstance(__uuidof(Recordset));
    
    _bstr_t strConnect = "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;\
                         User ID=sa;Initial Catalog=testdb;Data Source=192.168.1.3";
    
    _bstr_t bstrSQL("select * from testTable");
    try
    {
        m_pConnection->Open(strConnect, "","", adModeUnknown);
        m_pRecordset->Open(bstrSQL, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
        _variant_t vstr, vuint;
        while (!m_pRecordset->EndOfFile)
        {
            vstr = m_pRecordset->GetCollect("str");
            vuint = m_pRecordset->GetCollect("uint");
            
            string str = (_bstr_t)vstr.bstrVal;
            unsigned int uint = vuint.ulVal;
            m_pRecordset->MoveNext();
        }
        m_pRecordset->Close();
    }
    catch (_com_error e)
    {
        return 0;
    }

    if(m_pConnection->State)
    {
        m_pConnection->Close();
    }
    ::CoUninitialize();
    return 0;
}