ado连接mysql失败_为什么MFC通过ADO连接MySQL失败啊？

#import"c:\programfiles\commonfiles\system\ado\msado15.dll"no_namespacerename("EOF","rsEOF")CoInitialize(NULL);_ConnectionPtrpConn(_uuidof(Connection));_RecordsetPtrpRst(...

#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","rsEOF")

CoInitialize(NULL);

_ConnectionPtr pConn(_uuidof(Connection));

_RecordsetPtr pRst(_uuidof(Recordset));

pConn->ConnectionString = "Provider=SQLOLEDB.1;Password=root;Persist SecurityInfo=True;User ID=root;Initial Catalog=pubs";

pConn->Open("", "", "", adConnectUnspecified);

pRst = pConn->Execute("select * from authors", NULL, adCmdText);

while (!pRst->rsEOF)

{

((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->GetCollect("au_lname"));

pRst->MoveNext();

}

pRst->Close();

pConn->Close();

pRst.Release();

pConn.Release();

CoUninitialize();

为什么程序老式崩了，还有啊，ConnectingString里面的Provider是怎么知道的，我这个例子是从书上抄下来的，通过调试，错误应该是在pConn->Open("", "", "", adConnectUnspecified);这个地方

展开