On 12/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Tried this, but still not working. DO you know how to determine which version of DBI you are using?
Alternatively (to DBI->installed_versions): perl -MDBI -e 'print "$DBI::VERSION\n";' Your original connection notation - with the driver name as the fourth argument - is really old. It was deprecated a long time before the turn of the millennium. I don't know enough about Oracle connection notations to know how to help with slash vs anything else for an externally identified user. It seems logical to me that you'd provide the external user name to the connect string - but that's just what I'm used to on other DBMS. -----Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 20, 2006 11:10 AM [...] 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'. -----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?
-- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
