HRESULT hresult;
try
{
hresult = m_pConnection.CreateInstance(__uuidof(Connection));//创建Connection对象
if(SUCCEEDED(hresult))
{
hresult = m_pConnection->Open("Provider=SQLOLEDB;Server=127.0.0.1;Database=database;User Id=sa;Password=sa;","","",adModeUnknown);///连接数据库
///上面一句中连接字串中的Provider是针对SQL SERVER环境的;
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
}
try
{
pRs.CreateInstance(__uuidof(Recordset));
pRs->Open("select * from User",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
每次运行到这里pRs->Open("select * from User",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText)就出错
需要怎么改呢?
try
{
hresult = m_pConnection.CreateInstance(__uuidof(Connection));//创建Connection对象
if(SUCCEEDED(hresult))
{
hresult = m_pConnection->Open("Provider=SQLOLEDB;Server=127.0.0.1;Database=database;User Id=sa;Password=sa;","","",adModeUnknown);///连接数据库
///上面一句中连接字串中的Provider是针对SQL SERVER环境的;
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
}
try
{
pRs.CreateInstance(__uuidof(Recordset));
pRs->Open("select * from User",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
每次运行到这里pRs->Open("select * from User",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText)就出错
需要怎么改呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货