DBD::Oracle and external password store

I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.

Posted on 2007-05-21 14:17:42-07 by dorenma

Hi,
I'm trying to use DBD-Oracle together with the external password store (new in 10gR2).
I tried some variations to connect:

$dbh = DBI->connect('dbi:Oracle:DB','','') $dbh = DBI->connect('dbi:Oracle:DB','/','') $dbh = DBI->connect('dbi:Oracle:','/@DB') $dbh = DBI->connect('dbi:Oracle:','/@DB','') $dbh = DBI->connect('dbi:Oracle:', q{/@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST= foobar)(PORT=1521)) (CONNECT_DATA=(SID=ORCL)))}, "")

But I always get ORA-1017 Invalid username/password. Is anybody using the external password store with DBD-Oracle and knows how to get it working?
Thanks,
Matthias

Direct Responses: 5197 | Write a response

Posted on 2007-05-22 11:12:36-07 by byterock in response to 5185

Re: DBD::Oracle and external password store

No quick answer for you on this one but you would be much better off posting your question to dbi-users@perl.org (you don't need to subscribe in order to post) and you won't be automatically subscribed either. Very few people actully use or view this form for dbi or driver support. dbi-users is where you'll get the best support If external Password store is new in 10gR2 I do not see how DBD::Oracle can use it unless it is build directly into OCI. What version of DBI and DBD::Oracle are you using and which OCI client have you compiled against. Cheers

Direct Responses: Write a response