RE: perl DBD::Oracle and external password store

Thanks John for looking into it. I did my first test using DBD:Oracle 1.15 and oracle 10g client that is why it failed. I did another quick test with DBD::Oracle 1.21 and it works just fine.

Tao

-----Original Message-----
From: John Scoles [mailto:scoles_at_pythian.com] Sent: Monday, December 15, 2008 9:33 AM
To: jkstill_at_gmail.com
Cc: Wang, Tao; Oracle-L_at_freelists.org
Subject: Re: perl DBD::Oracle and external password store

I checked the OCI docs and there is noting special DBD::Oracle has to do

to use this store. It just has to be properly configured and you have to use a version of DBD:ORacle over 1.17 and a 10 client.

Looking into the code a little more DBD::ORacle before 1.17 uses the old

deprecated Proc connection methods to set up the environment. Later versions use the newer OCIEnvNlsCreate methods which should be compatible with the store

Cheers
John Scoles

Jared Still wrote:
> Wrong list.
>
> You need to go to http://lists.cpan.org/, find the dbi-users list, and

> sign up for that.
>
> No idea if the external password store works with it.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
> On Fri, Dec 12, 2008 at 2:34 PM, Wang, Tao <twang_at_iso-ne.com
> <mailto:twang_at_iso-ne.com>> wrote:
>
> I am trying to use perl DBI to connect oracle databases using the
> secure external password store introduced in oracle 10gR2. It
> works great when I use sqlplus connect after setting up the wallet
> and sqlnet.ora. And jdbc thick driver [jdbc:oracle:oci8] seems to
> be working fine with external password store as well. but I can
> not get it to work using perl DBI module, and I keep getting
> invalid username/password, or invalid names ... Does anyone know
if
> the perl DBI/DBD module work with external password store? Anyone
> has some experience with it? Any suggestion is great appreciated!
>
>
>
>
>
> I tried it on DBD:ORACLE version: 1.15 DBI version: 1.42 with
> oracle 10g2 client installed.
>
>
>
>
>
> Thanks,
>
> Tao
>
>

--
http://www.freelists.org/webpage/oracle-l