Mark,
Shouldn't the password be blank?
$dbh = $DBI->connect("dbi:Oracle:", "/", "", ...);
This is what I use for SYS connections, analogous to using the SQL*Plus
command 'connect / as sysdba'.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 10:58 AM
To: [email protected]
Subject: Unix: Oracle User Identified Externally
I am migrating an Oracle 9i to Oracle 10g database, and Perl 5.0.4 to
Perl 5.8.7 in Sun Solaris environment.
My old Perl/DBI script was able to connect via this method:
use DBI;
$dbd = 'Oracle';
$user = '/'; $password = '/';
$dbh = DBI->connect ($dbname, $user, $password, $dbd);
This is not working with new version of Perl/DBI.
I have changed script to connect correctly:
use DBI;
$dbd = 'Oracle';
$user = 'scott'; $password = 'tiger';
$dbh = DBI->connect ("dbi:$dbd:$dbname",$user, $password);
But need to be able to connect with user identified externally (as
before).
I cannot find documentation on proper syntax or if a fix was made in
later version of DBI.
Can anyone help?
Mark Cummings
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
