he
I try to connect to database but the name of it ('tra3') is wrong, however
it exist in net manager and I can connect to it from enterprice manager or
QSL Plus Worksheet

t.


I use VC++6 and Oracle 10:
C++:
int sql_Test_3(CString strCnn_tmp)
{
ODatabase datab;
ODynaset dyn;
double sum=0.0;
double cursal;
datab.Open("tra3", "user", "password");
dyn.Open(datab, "select SYS.V_$SQLAREA.SQL_TEXT,
length(SYS.V_$SQLAREA.SQL_TEXT), SYS.V_$SQLAREA.SQL_ID from SYS.V_$SQLAREA
where SQL_ID='bty8k0wzhaqku'");
while (!dyn.IsEOF())
{
dyn.GetFieldValue("sql_id", &cursal);
dyn.MoveNext();
}
return 0;
}







TRA3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 195.163.205.209)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tra3)
)
)