// AccessSqlserverByAdo.cpp : 定义控制台应用程序的入口点。//#include "stdafx.h"#include <Windows.h>#include <iostream>#include <string>using namespace std;#import "C:\Program Files\Common Files\System\ado\msado15.dll" rename("EOF", "adoEOF") rename("BOF", "adoBOF")using namespace ADODB;int _tmain(int argc, _TCHAR* argv[]){    ::CoInitialize(NULL);       _ConnectionPtr m_pConnection=NULL;          m_pConnection.CreateInstance(__uuidof(Connection));              _bstr_t strConnect = "Provider=SQLOLEDB.1;Password=1111111;Persist Security Info=True; \                         User ID=sa;Initial Catalog=SoftwareVerification;Data Source=112.74.105.204";         //下面代码执行一个查询    /*    try    {        _RecordsetPtr m_pRecordset=NULL;       m_pRecordset.CreateInstance(__uuidof(Recordset));        m_pConnection->Open(strConnect,"","",adModeUnknown);        _variant_t vAffected;        _bstr_t bstrSql("select user_name,user_password from userssss");        m_pRecordset = m_pConnection->Execute(bstrSql,&vAffected,adCmdText);        while(!m_pRecordset->adoBOF)        {            _variant_t UserName = m_pRecordset->GetCollect(_variant_t((long)0));            _variant_t PassWord = m_pRecordset->GetCollect("user_password");            if(UserName.vt != NULL)            {                cout<<(LPCSTR)(_bstr_t)UserName<<"   "<<(LPCSTR)(_bstr_t)PassWord<<endl;            }            m_pRecordset->MoveNext();        }        m_pRecordset->Close();        m_pConnection->Close();    }    catch(_com_error e)    {        wcout<<e.Description()<<endl;    }    */    //调用存储过程        try    {        m_pConnection->Open(strConnect,"","",adModeUnknown);        _CommandPtr cmmd;        HRESULT hr = cmmd.CreateInstance(__uuidof(Command));        cmmd->Parameters->Append(cmmd->CreateParameter(_bstr_t("Return"),adInteger,adParamReturnValue,4));        cmmd->Parameters->Append(cmmd->CreateParameter(_bstr_t("strUserName"),adVarChar,adParamInput,50,"zds"));        cmmd->Parameters->Append(cmmd->CreateParameter(_bstr_t("strPassWord"),adVarChar,adParamInput,50,"111"));        cmmd->Parameters->Append(cmmd->CreateParameter(_bstr_t("nSoftWareID"),adInteger,adParamInput,4,"1"));        cmmd->Parameters->Append(cmmd->CreateParameter(_bstr_t("strMsg"),adVarChar,adParamOutput,50));                cmmd->CommandText = _bstr_t("UserLogin");        cmmd->ActiveConnection = m_pConnection;        cmmd->CommandType = adCmdStoredProc;        cmmd->Execute(NULL,NULL,adCmdStoredProc);        string strRet = (const char*)(_bstr_t)cmmd->Parameters->GetItem("strMsg")->GetValue();        int nRet = cmmd->Parameters->GetItem("Return")->GetValue();        cout<<strRet<<endl;    }    catch(_com_error e)    {        wcout<<e.Description()<<endl;    }    ::CoUninitialize();    return 0;}