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...
