RE: Unix: Oracle User Identified Externally

Tried this, but still not working. DO you know how to determine which
version of DBI you are using?

Mark Cummings

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, December 20, 2006 11:10 AM
To: Cummings, Mark; dbi-users@xxxxxxxx
Subject: RE: Unix: Oracle User Identified Externally

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: Mark.Cummings@xxxxxxxxxxxxxx [mailto:Mark.Cummings@xxxxxxxxxxxxxx]

Sent: Wednesday, December 20, 2006 10:58 AM
To: dbi-users@xxxxxxxx
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.



.

Quantcast