More info on the oracle 8 external setup: SQL> show parameter os_authent_prefix;
NAME TYPE VALUE ------------------------------------ ------- --- os_authent_prefix string Notice no value just to complicate it more :-) SQL> select USERNAME,PASSWORD from dba_users; OW_ADMIN_UTILS 26749C6AA7E5A212 MYUSER EXTERNAL OWPROJECT F068F107BFFB41DD On Thu, 2009-10-29 at 05:15 -0400, jeff wrote: > Asked a question yesterday but I don't think I worded it very well so > heres another try. > > I want to do an 'external connection' (i.e., No user or password > supplied in DBI->connect ) from a single script to multiple versions of > Oracle ( Oracle 8 & 10 ). > > What I have found so far is that Oracle.pm built againt the 10 client > works great with the wallet (No user or password supplied in > DBI->connect ) but will not connect to 8 without a username/password. > > Oracle.pm built against 8 works great with Oracle 8 when doing an > 'external connection' (i.e., No user or password supplied in > DBI->connect ) but will not connect to 10 without a username/password. > > Each version of Oracle uses a different mechanism to do an 'external > connect' and they seem to have opted for NO backward compatibility in > this regard. > > Anyone solved this ? > > Thanks. > > >
