VC连接SQL2005(例子ADO_2)

(1)    在StdAfx.h中添加下面一句话：

#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF", "rsEOF")

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83

(2)    void CADO_2Dlg::OnBtnQuery()   {          CoInitialize(NULL);                                                        // 初始化COM库          _ConnectionPtr pConn(__uuidof(Connection));          // 建立Connection          _RecordsetPtr pRst(__uuidof(Recordset));          // 建立Recordset               _CommandPtr pCmd(__uuidof(Command));                     // 建立Command               try          {                 //pConn->ConnectionString = "Provider=SQLOLEDB;Password=XXX;Persist Security Info=True;User ID=sa;Initial Catalog=pubs";       //此句正确                 pConn->ConnectionString = "driver={SQL Server};Server=(local);DATABASE=pubs;UID=sa;PWD=xxx";                 pConn->Open("", "", "", adConnectUnspecified);                      //pRst = pConn->Execute("select * from authors", NULL, adCmdText);                 //pRst->Open("select * from authors", _variant_t((IDispatch*) pConn), adOpenDynamic, adLockOptimistic, adCmdText);                 pCmd->put_ActiveConnection(_variant_t((IDispatch*) pConn));                 pCmd->CommandText = "select * from authors";                 pRst = pCmd->Execute(NULL, NULL, adCmdText);                           while(!pRst->rsEOF)                 {                        ((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->GetCollect("au_lname")); //查询au_lname字段                        pRst->MoveNext();                 }          }          catch(_com_error e)          {                 CString errormessage;                 errormessage.Format("Error: %s", e.ErrorMessage());                 AfxMessageBox(errormessage);          }               AfxMessageBox("查询结束!");               pRst->Close();          pConn->Close();          pRst.Release();                                                               // 释放相应COM接口上的引用计数          pConn.Release();          CoUninitialize();                                                       // 卸载COM库   }