Recordset的Open方法失败,该怎么处理

Recordset的Open方法失败
数据库连接成功，但是下面的查询失败。请找出原因。
CString strSql = "";
strSql.Format("select usrname, usrpwd from dbo.[login] where usrname = '%s' and usrpwd = '%s'", m_usrName, m_usrPwd);
try
{
m_rst->Open((_bstr_t)strSql, "", adOpenStatic, adLockOptimistic, adCmdUnknown);
}
catch(...)
{
AfxMessageBox("查询数据库失败！");
return;
}

[解决办法]

C/C++ code

strSRC.Format(_T("Driver=SQL Server;server=%s;Database=%s;UID=%s;PWD=%s"),数据库ip地址,库名,用户,密码);_variant_t varSRC(strSRC);_variant_t varSQL(strSql);try{    m_rst->Open(varSQL,varSRC,adOpenStatic,adLockOptimistic,adCmdText)}catch(_com_error& e){    CString err = e.ErrorMessage();}