MFC连接数据库如何用 pConn->ConnectionString="Provider=SQLOLEDB.1;Password=123456;Persis

MFC连接数据库怎么用 pConn->ConnectionString="Provider=SQLOLEDB.1;Password=123456;Persis
pConn->ConnectionString="Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=ao;Data source=F:\database\data\ApressFinancial.mdf;Initial Catalog=ApressFinancial";

这里填写对吗

我自己新建了一个名叫ao 名为123456的是sql账户

怎连接呢由孙鑫的改的

C/C++ code

void CAdoDlg::OnBtnQuery() 
{
    // TODO: Add your control notification handler code here
    CoInitialize(NULL);
    _ConnectionPtr pConn(__uuidof(Connection));
    _RecordsetPtr pRst(__uuidof(Recordset));
    _CommandPtr pCmd(__uuidof(Command));

    //pConn->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs";
    pConn->ConnectionString="Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=ao;Data source=F:\database\data\ApressFinancial.mdf;Initial Catalog=ApressFinancial";
    pConn->Open("","","",adConnectUnspecified);

    pRst=pConn->Execute("select * from Shares",NULL,adCmdText);
    while(!pRst->rsEOF)
    {
        ((CListBox*)GetDlgItem(IDC_LIST1))->AddString(
            (_bstr_t)pRst->GetCollect("ShareDesc"));
        pRst->MoveNext();
    }
    
    pRst->Close();
    pConn->Close();
    pCmd.Release();
    pRst.Release();
    pConn.Release();
    CoUninitialize();
}

------解决方案--------------------
Provider=SQLOLEDB.1这句要和本地计算机装的驱动版本有关,另外,你也没说程序是不是有问题,如果有问题是什么问题,这怎么判断,单看代码一般看不出有什么问题,再说多数人也不会有太多时间仔细看代码

MFC连接数据库 如何用 pConn->ConnectionString="Provider=SQLOLEDB.1;Password=123456;Persis

相关推荐

MFC连接数据库如何用 pConn->ConnectionString="Provider=SQLOLEDB.1;Password=123456;Persis