![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
this command connects to oracle: $ sqlplus smiller/mill99@oradev A OTL based program which uses smiller/mill99@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: EFAULT);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) |
#3
| |||
| |||
|
|
Shane wrote: this command connects to oracle: $ sqlplus smiller/mill99@oradev A OTL based program which uses smiller/mill99@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: EFAULT);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... |
![]() |
| Thread Tools | |
| Display Modes | |
| |