Am I the only one amused by the fact that in a thread about Oracle we have a thread with writers "Scott" and "Tiger"?
On Wed, Oct 5, 2011 at 9:41 AM, tiger peng <tigerpeng2...@yahoo.com> wrote: > You passed the full description to SQL*Plus. Try to assign it to your > $dsnorCheck where is the tnsnames.ora (and sqlnet.ora)? what is the valuess > for env varialbles ORACLE_HOME and TNS_ADMIN > > > Why use ODBC driver instead of Oracle? > > > > ________________________________ > From: Scott Stansbury <sstansb...@aol.com> > To: "Nelson, Erick [HDS]" <erick.nel...@hdsupply.com> > Cc: dbi-users@perl.org > Sent: Wednesday, October 5, 2011 11:22 AM > Subject: Re: :ODBC fails, SQL*Plus works > > I'm sorry - that was just fat fingers on the cut/paste... > > In actuality it is $oracle_host = "192.168.15.200:1535" > > > On Oct 5, 2011, at 12:13 PM, Nelson, Erick [HDS] wrote: > > Your $oracle_host Perl var looks like it has more that just the host ip > > address and port in it. What is the 10.128 ? > > > > -----Original Message----- > > From: Scott Stansbury [mailto:sstansb...@aol.com] > > Sent: Wednesday, October 05, 2011 9:09 AM > > To: dbi-users@perl.org > > Subject: DBD::ODBC fails, SQL*Plus works > > > > Folks, > > > > I could use a tip or lead with the following issue: > > > > I have a Windows Server 2008 R2 box with Oracle Instant Client 11.2, > > with the SQL*Plus and ODBC modules installed. No other Oracle software > > is installed. > > > > I am connecting to an Oracle 10g instance. The following SQL*Plus works: > > > > sqlplus > > user/passwd@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192. > > 168.15.200)(PORT=1535)))(CONNECT_DATA=(SID=PROD77))). > > > > The perl script that contains the following does not: > > > > use DBI; > > > > # Oracle / Remedy info > > > > my $oracle_sid = "PROD77"; > > my $oracle_host = "192.168.15.200:1535"; > > > > my $oracle_userid = "user"; > > my $oracle_passwd = "passwd"; > > ################ > > > > my $dsn = "Driver={Oracle in > > instantclient_11_2};server=$oracle_host;sid=$oracle_sid"; > > > > my $dbh = DBI->connect("dbi:ODBC:$dsn", "$oracle_userid", > > "$oracle_passwd"); > > > > It returns (after a few seconds) with an ORA-12154 error: TNS:could not > > resolve the connect identifier specified ( SQL-08004). > > > > Thanks for any help... > > > > Scott... > > > > > > > > > > > > Scott... > -- Check out my LEGO blog at http://www.brickpile.com/ View my photos at http://flickr.com/photos/billward/ Follow me at http://twitter.com/williamward
