程序如下:
//程序开始
try
{
//初始化连接
m_pCommand.CreateInstance(__uuidof(Command));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pCommand->ActiveConnection = m_pConnection; //连接ORACLE
tm_strConnection = "Provider=MSDAORA; Data Source=gis; User ID=system; Password=manager";
tm_hResult = m_pConnection.CreateInstance("ADODB.Connection");
//连接ACCESS
//tm_strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:\\workshop\\gis\\design\\db1.mdb";
if(SUCCEEDED(tm_hResult))
{
tm_hResult = m_pConnection->Open
((_bstr_t)tm_strConnection,"","",-1);
} //打开t_matrix表
m_pRecordset->Open(_variant_t("t_matrix"),
_variant_t((IDispatch *)m_pConnection,true),
adOpenDynamic, adLockOptimistic, adCmdTable); //插入新纪录
m_pRecordset->AddNew();
//到这出错:“当前 Recordset 不支持更新。这可能是提供者限制的,也可能是选定 的 锁定类型限制的”
}
catch(...)
{
CCommon tm_common;
AfxMessageBox(tm_common.DisplayAdoError(m_pConnection));
}
//程序结束
//程序开始
try
{
//初始化连接
m_pCommand.CreateInstance(__uuidof(Command));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pCommand->ActiveConnection = m_pConnection; //连接ORACLE
tm_strConnection = "Provider=MSDAORA; Data Source=gis; User ID=system; Password=manager";
tm_hResult = m_pConnection.CreateInstance("ADODB.Connection");
//连接ACCESS
//tm_strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:\\workshop\\gis\\design\\db1.mdb";
if(SUCCEEDED(tm_hResult))
{
tm_hResult = m_pConnection->Open
((_bstr_t)tm_strConnection,"","",-1);
} //打开t_matrix表
m_pRecordset->Open(_variant_t("t_matrix"),
_variant_t((IDispatch *)m_pConnection,true),
adOpenDynamic, adLockOptimistic, adCmdTable); //插入新纪录
m_pRecordset->AddNew();
//到这出错:“当前 Recordset 不支持更新。这可能是提供者限制的,也可能是选定 的 锁定类型限制的”
}
catch(...)
{
CCommon tm_common;
AfxMessageBox(tm_common.DisplayAdoError(m_pConnection));
}
//程序结束
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货