_ConnectionPtr pConn;
_RecordsetPtr  pRs;
CString strSQL;
pConn.CreateInstance(__uuidof(Connection));
pRs.CreateInstance("ADODB.Recordset");pConn->CursorLocation=adUseClient;

strSQL="Provider=SQLOLEDB;Server=ys;DataBase=db_work_gg;UID=sa;PWD=";
UpdateData(TRUE);strSQL = "select * from u_gg_xwlx where dm_xmlx = '01'";pRs->Open(_bstr_t(strSQL),_variant_t((IDispatch*)   pConn,true),adOpenStatic,AdLockOptimistic,adCmdText);编译时提示:error C2065: “AdLockOptimistic” : 未声明的标识符
但是我觉得我写对了!