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

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这句要和本地计算机装的驱动版本有关,另外,你也没说程序是不是有问题,如果有问题是什么问题,这怎么判断,单看代码一般看不出有什么问题,再说多数人也不会有太多时间仔细看代码

查看更多 下一篇