其中的ADODB.Connection中的连接字符串怎么写

provider=oraoledb.oracle;data source=your data source;user id=your user;password=your pwd


可以连接的。下面的串就可以连接成功。
Provider=OraOLEDB.Oracle.1;Password=xxx;Persist Security Info=True;User ID=userName;Data Source=dnsName


这样的连接串可以,我试用通过:
CString m_sConn="Provider=OraOLEDB.Oracle.1;Password=test;Persist Security Info=True;User ID=test;Data Source=\"(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.115)(PORT = 1521)) )(CONNECT_DATA = (SID = ora8)))\"";



BOOL CDataTrans2Dlg::SetADOEnv()
{
CString szLocalConn="Provider=MSDAORA.1;User ID=user_name;Password=user_pass;Data Source=database_name";
pConnection=0;
pConnection.CreateInstance("ADODB.Connection");
//pConnection->ConnectionTimeout = 10;
DispLog("connect oracle...");
try
{
HRESULT hr = pConnection->Open((_bstr_t)szLocalConn, "", "", adConnectUnspecified);
if (FAILED(hr))
{
DispLog("connect failed...");
return FALSE;
}
}
catch(_com_error e)