Sorry - snow bound for 2 days. To determine DBI version: $ perl -CDBI -e 'print $DBI::Version"
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 20, 2006 1:32 PM To: Reidy, Ron; [email protected] Subject: 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:[EMAIL PROTECTED] Sent: Wednesday, December 20, 2006 11:10 AM To: Cummings, Mark; [email protected] 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: [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.
