Re: sqlplus v. OCI v. OCCI connect
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sat, 02 May 2009 00:25:43 +0200
Message-ID: <49fb76ed$0$187$e4fe514c_at_news.xs4all.nl>
>> this command connects to oracle:
>>
>> $ sqlplus smiller/mill99_at_oradev
>>
>> A OTL based program which uses smiller/mill99_at_oradev as a connection
>> string connects to Oracle.
>> A working OCI program here which was gutted to use user=smiller,
>> password=mill99, db=oradev connects to Oracle.
>>
>> But an OCCI program with this code:
>>
>> 52 Environment* const env = Environment::createEnvironment(
>> 53 Environment::DEFAULT);
>> 54
>> 55 // Open a connection to the database, then close it.
>> 56 //
>> 58 try
>> 59 {
>> 60 Connection* const con = env->createConnection(user, pass,
>> osid);
>>
>> throws on line 60 giving:
>>
>> Can't connect: ORA-01017: invalid username/password; logon denied
>>
>> What in the heck is the deal with OCCI? My OTL code worked the first
>> time, no problem. I guess OTL is based on OCI, which works How is
>> connecting to the db with OCCI so different from OCI, OTL, sqlplus?
>> How can I fix this error?
>>
>> tnsping oradev gives:
>>
>> $ tnsping oradev
>>
>> TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 30-
>> APR-2009 19:11:28
>>
>> Copyright (c) 1997, 2006, Oracle. All rights reserved.
>>
>> Used parameter files:
>>
>> Used TNSNAMES adapter to resolve the alias
>> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
>> (PROTOCOL = TCP)(HOST = sundev16)(PORT = 28538))) (CONNECT_DATA =
>> (SERVICE_NAME = oradev.bloomberg.com)))
>> OK (10 msec)
Date: Sat, 02 May 2009 00:25:43 +0200
Message-ID: <49fb76ed$0$187$e4fe514c_at_news.xs4all.nl>
Michael Austin schreef:
> Shane wrote:
>> this command connects to oracle:
>>
>> $ sqlplus smiller/mill99_at_oradev
>>
>> A OTL based program which uses smiller/mill99_at_oradev as a connection
>> string connects to Oracle.
>> A working OCI program here which was gutted to use user=smiller,
>> password=mill99, db=oradev connects to Oracle.
>>
>> But an OCCI program with this code:
>>
>> 52 Environment* const env = Environment::createEnvironment(
>> 53 Environment::DEFAULT);
>> 54
>> 55 // Open a connection to the database, then close it.
>> 56 //
>> 58 try
>> 59 {
>> 60 Connection* const con = env->createConnection(user, pass,
>> osid);
>>
>> throws on line 60 giving:
>>
>> Can't connect: ORA-01017: invalid username/password; logon denied
>>
>> What in the heck is the deal with OCCI? My OTL code worked the first
>> time, no problem. I guess OTL is based on OCI, which works How is
>> connecting to the db with OCCI so different from OCI, OTL, sqlplus?
>> How can I fix this error?
>>
>> tnsping oradev gives:
>>
>> $ tnsping oradev
>>
>> TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 30-
>> APR-2009 19:11:28
>>
>> Copyright (c) 1997, 2006, Oracle. All rights reserved.
>>
>> Used parameter files:
>>
>> Used TNSNAMES adapter to resolve the alias
>> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
>> (PROTOCOL = TCP)(HOST = sundev16)(PORT = 28538))) (CONNECT_DATA =
>> (SERVICE_NAME = oradev.bloomberg.com)))
>> OK (10 msec)
> > > is there a reason why you are multi-posting in all of the oracle NGs? > Those of us that follow on, generally follow all...
Which makes me wonder: why not make one group instead of three? Saves us twice the spam!
Shakespeare Received on Sat May 02 2009 - 00:25:43 CEST