ADO基础知识:使用Connection对象连接数据库

来源:互联网 发布:时时彩开奖采集器源码 编辑:程序博客网 时间:2024/05/22 16:42

使用ADO中的Connection对象连接数据库:


int _tmain(int argc, _TCHAR* argv[])
{
    CoInitialize(NULL);
    Connection15Ptr pConnect;
    HRESULT RET;
    try { 
    RET  = pConnect.CreateInstance("ADODB.Connection");
    
    pConnect->PutConnectionString("Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=.");
    pConnect->PutConnectionTimeout(10);
    pConnect->PutCursorLocation(adUseClient);


    pConnect->Open(_bstr_t(""),_bstr_t(""),_bstr_t(""),adConnectUnspecified);
    cout<<"登录成功了..\n";
    pConnect->Close();
    }
    catch(_com_error &e)
    {
        if(pConnect)
        cout<<"Error"<<(LPCSTR)e.Description()<<endl;
        else
            cout<<"connection 未初始..."<<endl;
    }
    CoUninitialize();
return 0;
}

原创粉丝点击