ado连接oracle数据库的问题
AfxOleInit();///初始化COM库
////////////连接数据库//////////////
HRESULT hr;
_ConnectionPtr m_pConnection;
try
{
hr = m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
if(SUCCEEDED(hr))
{
hr = m_pConnection->Open("Provider=MSDAORA;Data Source=SUBDBMS","TSC_ADMIN","TMRI_TSC_2004",adModeUnknown);///连接数据库
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
return FALSE;
}
printf("success");
_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance(__uuidof(Recordset));
hr = m_pRecordset->Open("SELECT * FROM TSC_ADMIN.TEST",_variant_t((IDispatch *)m_pConnection,true),adOpenDynamic,adLockOptimistic,adCmdText); // 执行到这句话出现异常,请问什么原因阿?
if(SUCCEEDED(hr))
{
printf("open record set success\n");
}
m_pRecordset->AddNew();
m_pRecordset->PutCollect("ID",_variant_t("44"));
m_pRecordset->Update();
刚学,请大家指教!!