请问在vc++中如何用啊ado访问oracle数据库并打开记录集？

Question

请问在vc++中如何用啊ado访问oracle数据库并打开记录集？

Answer 1

_pConOracle.CreateInstance("ADODB.Connection");
/******************连接数据库********************/
try
{
_pConOracle->ConnectionTimeout = 8;
_pConOracle->Open("Provider=oraoledb.oracle;Data Source=wztc;User ID=WZTC;Password=KWZTCJL;PLSQLRSet=1","","",adModeUnknown);
}
catch(_com_error e)///捕捉异常
{
} strsql="select * from vio_zongdwtcl";
_pROracle.CreateInstance("ADODB.Recordset");
try
{
_pROracle->CursorLocation=adUseClient;
_pROracle->Open((_variant_t)strsql,_variant_t((IDispatch *)(_pConOracle),true),adOpenStatic,adLockBatchOptimistic,adCmdText);
}
catch (_com_error e)
{
}
这样就得到了一个记录集pROracle

Answer 2

连接失败。我用的是oracle9i

Answer 3

m_pConnection->Open("Provider=OraOLEDB.Oracle;Password=xxx;Data Source=xxx;User ID=xxx","","",1,adModeUnknown)