Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.72.MISMATCH!eweka.nl!hq-usenetpeers.eweka.nl!newsfeed101.telia.com!nf02.dk.telia.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Date: Sat, 02 May 2009 00:25:43 +0200 From: Shakespeare User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.tools Subject: Re: sqlplus v. OCI v. OCCI connect References: <3d098c75-0de5-4c4e-804c-9aed3e5c5cfd@z23g2000prd.googlegroups.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 57 Message-ID: <49fb76ed$0$187$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: 82.95.215.210 X-Trace: 1241216749 news.xs4all.nl 187 [::ffff:82.95.215.210]:55316 X-Complaints-To: abuse@xs4all.nl Xref: news.cambrium.nl Michael Austin schreef: > 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::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