Is: mp3i
listed in your: tnsnames.ora file?
From what I see, it really looks like an issue with your "mp3i" not
being a known service.
Capacio, Paula J wrote:
Capacio, Paula J wrote:
Hello, I'm hoping someone can explain why one of these connect
statements work and the other doesn'
Capacio, Paula J [mailto:[EMAIL PROTECTED] wrote:
>> The code now looks like:
>> my $dbh;
>> if ($method =~ /2/) { #this works
>> $dbh = DBI->connect('', "scott/tiger", '', 'Oracle')
>>or die "Connect failed: $DBI::errstr\n";
>> }else{ #this doesn't
>> printIt("Just prior to c
Capacio, Paula J [mailto:[EMAIL PROTECTED] wrote:
> The code now looks like:
> my $dbh;
> if ($method =~ /2/) { #this works
> $dbh = DBI->connect('', "scott/tiger", '', 'Oracle')
>or die "Connect failed: $DBI::errstr\n";
> }else{ #this doesn't
> printIt("Just prior to connect
Capacio, Paula J wrote:
>>Hello, I'm hoping someone can explain why one of these connect
>>statements work and the other doesn't. The script sets environment
>>values as such: $ENV{ORACLE_HOME} = "/usr/oracle/product/8.1.7_64";
>>$ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via
>>
Message-
From: Reidy, Ron
Sent: Wednesday, February 15, 2006 9:19 PM
To: Capacio, Paula J; dbi-users@perl.org
Subject: RE: Insights into DBI->connect differences
The Oracle error docs are your friend:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525.pdf
--
Ron Reidy
Lead
The Oracle error docs are your friend:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525.pdf
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Capacio, Paula J [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 15, 2006 1:37 PM
To: dbi-users@perl.org
Capacio, Paula J wrote:
Hello, I'm hoping someone can explain why one of these connect
statements work and the other doesn't.
The script sets environment values as such:
$ENV{ORACLE_HOME} = "/usr/oracle/product/8.1.7_64";
$ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via
$ARGV[1]
