Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle 10 and C++

Oracle 10 and C++

From: tomek <e_at_rt.up>
Date: Thu, 15 Dec 2005 15:17:46 +0100
Message-ID: <dnrtsl$793$1@atlantis.news.tpi.pl>


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)
    )
  ) Received on Thu Dec 15 2005 - 08:17:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US