出错了,请指教.

[hljqfl]

_RecordsetPtr m_trecordset;
m_trecordset.CreateInstance(__uuidof(Recordset));
m_trecordset->Open("select * from 表名", theApp.m_pConnection.GetInterfacePtr(), adOpenStatic,adLockOptimistic,adCmdText);

这样可以,
如果
str_sql=Open("select * from 表名");
m_trecordset->Open(str_sql, theApp.m_pConnection.GetInterfacePtr(), adOpenStatic,adLockOptimistic,adCmdText);

提示错误信息,是类型转换问题,不知该如何解决.
cannot convert from 'class CString' to 'const class _variant_t'

[Qiushen]

你的参数里本来就要求是一条文本命令，adCmdText

[hljqfl]

up

[hrbqfl]

m_trecordset->Open(LPCTSTR(str_sql), theApp.m_pConnection.GetInterfacePtr(), adOpenStatic,adLockOptimistic,adCmdText);